{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Base de données","LISTES","Dépôt des Licences","Jury","Match 1 recto","Match 1 verso","Match 2 recto","Match 2 verso","Match 3 recto","Match 3 verso","Match 4 recto","Match 4 verso","Rapport sur la compatibilité"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":19,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Base de données","index":0,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Type de CDC",null,"      Cliquer sur la flèche à droite de la cellule et choisir le type de CRC dans la liste proposée"]
["Date",null,"<------ taper la date sous la forme suivante : 16/10/23"]
["Heure",null,"<------ taper l'heure sous la forme suivante : 16:30"]
["Division - Groupe",null,"      Cliquer sur la flèche à droite de la cellule et choisir la division/groupe dans la liste proposée"]
["Lieu"]
[]
["Match 1 Nom du Club A",null,null,null,null,"<------ cliquer sur le bouton à gauche pour enregistrer les licences"]
["Match 1 Nom du Club B",null,null,null,null,"<------ cliquer sur le bouton à gauche pour enregistrer les licences"]
[]
["Match 2 Nom du Club A",null,null,null,null,"<------ cliquer sur le bouton à gauche pour enregistrer les licences"]
["Match 2 Nom du Club B",null,null,null,null,"<------ cliquer sur le bouton à gauche pour enregistrer les licences"]
[]
["Match 3 Nom du Club A",null,null,null,null,"<------ cliquer sur le bouton à gauche pour enregistrer les licences"]
["Match 3 Nom du Club B",null,null,null,null,"<------ cliquer sur le bouton à gauche pour enregistrer les licences"]
[]
["Match 4 Nom du Club A",null,null,null,null,"<------ cliquer sur le bouton à gauche pour enregistrer les licences"]
["Match 4 Nom du Club B",null,null,null,null,"<------ cliquer sur le bouton à gauche pour enregistrer les licences"]
[]
["Nom du Délégué",null,"<------ taper le nom du délégué en majuscule"]
["Prénom du Délégué",null,"<------ taper le prénom du délégué avec son initiale en majuscule et la suite en minuscule"]
[]
["Nom de l'Arbitre",null,"<------ taper le nom de l'arbitre en majuscule"]
["Prénom de l'Arbitre",null,"<------ taper le prénom de l'arbitre avec son initiale en majuscule et la suite en minuscule"]

{"sheet":"LISTES","index":1,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[null,"Type","Division"]
[null,"OPEN","1 - A"]
[null,"FEMININ","1 - B"]
[null,"VETERAN","2 - A"]
[null,null,"2 - B"]
[null,null,"2 - C"]
[null,null,"2 - D"]
[null,null,"3 - A"]
[null,null,"3 - B"]
[null,null,"3 - C"]
[null,null,"3 - D"]
[null,null,"3 - E"]
[null,null,"3 - F"]
[null,null,"3 - G"]
[null,null,"3 - H"]
[null,null,"F - 1 A"]
[null,null,"F - 1 B"]
[null,null,"F - 2 A"]
[null,null,"F - 2 B"]
[null,null,"F - 2 C"]
[null,null,"F - 2 D"]
[null,null,"F - 2 E"]
[null,null,"F - 2 F"]
[null,null,"F - 2 G"]

{"sheet":"Dépôt des Licences","index":2,"n_rows":167,"n_cols":24,"rows_kept":167,"cut":false,"hidden":false,"merged":[[34,0,35,20],[122,0,123,20],[44,0,44,18],[45,9,45,13],[56,0,57,20],[66,0,66,18],[67,9,67,13],[78,0,79,20],[88,0,88,18],[89,9,89,13],[100,0,101,20],[110,0,110,18],[111,9,111,13],[22,0,22,18],[23,9,23,13],[12,0,13,20],[1,9,1,13],[0,0,0,18],[166,0,167,20],[132,0,132,18],[133,9,133,13],[144,0,145,20],[154,0,154,18],[155,9,155,13]]}
[{"$f":"\"Passez La licence : Capitaine en Premier en cellule A3 fond jaune, puis les joueurs à partir de A4\"","v":"Passez La licence : Capitaine en Premier en cellule A3 fond jaune, puis les joueurs à partir de A4"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(V1)","v":2024},{"$f":"TODAY()","v":45337}]
["Nom","Prénom","Date Nais.","Nat.","Sexe",null,null,"N° Licence","N° Club",null,null,null,null,null,"Certificat","AR","Clas.","Cat.","Mut."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,{"$f":"'Base de données'!B1","v":0},{"$f":"IF(W11=\"FEMININ\",\"F\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Base de données'!B1","v":0},{"$f":"IF(W12=\"VETERAN\",\"V\",\"\")","v":""}]
[{"$f":"'Base de données'!B7","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Passez La licence : Capitaine en Premier en cellule A25 fond jaune, puis les joueurs à partir de A26\"","v":"Passez La licence : Capitaine en Premier en cellule A25 fond jaune, puis les joueurs à partir de A26"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(V23)","v":1900}]
["Nom","Prénom","Date Nais.","Nat.","Sexe",null,null,"N° Licence","N° Club",null,null,null,null,null,"Certificat","AR","Clas.","Cat.","Mut."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[{"$f":"'Base de données'!B8","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Passez La licence : Capitaine en Premier en cellule A47 fond jaune, puis les joueurs à partir de A48\"","v":"Passez La licence : Capitaine en Premier en cellule A47 fond jaune, puis les joueurs à partir de A48"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(V45)","v":1900}]
["Nom","Prénom","Date Nais.","Nat.","Sexe",null,null,"N° Licence","N° Club",null,null,null,null,null,"Certificat","AR","Clas.","Cat.","Mut."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[{"$f":"'Base de données'!B10","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Passez La licence : Capitaine en Premier en cellule A69 fond jaune, puis les joueurs à partir de A70\"","v":"Passez La licence : Capitaine en Premier en cellule A69 fond jaune, puis les joueurs à partir de A70"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(V67)","v":1900}]
["Nom","Prénom","Date Nais.","Nat.","Sexe",null,null,"N° Licence","N° Club",null,null,null,null,null,"Certificat","AR","Clas.","Cat.","Mut."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[{"$f":"'Base de données'!B11","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Passez La licence : Capitaine en Premier en cellule A91 fond jaune, puis les joueurs à partir de A92\"","v":"Passez La licence : Capitaine en Premier en cellule A91 fond jaune, puis les joueurs à partir de A92"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(V89)","v":1900}]
["Nom","Prénom","Date Nais.","Nat.","Sexe",null,null,"N° Licence","N° Club",null,null,null,null,null,"Certificat","AR","Clas.","Cat.","Mut."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[{"$f":"'Base de données'!B13","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Passez La licence : Capitaine en Premier en cellule A113 fond jaune, puis les joueurs à partir de A114\"","v":"Passez La licence : Capitaine en Premier en cellule A113 fond jaune, puis les joueurs à partir de A114"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(V111)","v":1900}]
["Nom","Prénom","Date Nais.","Nat.","Sexe",null,null,"N° Licence","N° Club",null,null,null,null,null,"Certificat","AR","Clas.","Cat.","Mut."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[{"$f":"'Base de données'!B14","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Passez La licence : Capitaine en Premier en cellule A135 fond jaune, puis les joueurs à partir de A136\"","v":"Passez La licence : Capitaine en Premier en cellule A135 fond jaune, puis les joueurs à partir de A136"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(V133)","v":1900}]
["Nom","Prénom","Date Nais.","Nat.","Sexe",null,null,"N° Licence","N° Club",null,null,null,null,null,"Certificat","AR","Clas.","Cat.","Mut."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[{"$f":"'Base de données'!B16","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Passez La licence : Capitaine en Premier en cellule A157 fond jaune, puis les joueurs à partir de A158\"","v":"Passez La licence : Capitaine en Premier en cellule A157 fond jaune, puis les joueurs à partir de A158"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(V155)","v":1900}]
["Nom","Prénom","Date Nais.","Nat.","Sexe",null,null,"N° Licence","N° Club",null,null,null,null,null,"Certificat","AR","Clas.","Cat.","Mut."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[{"$f":"'Base de données'!B17","v":0}]

{"sheet":"Jury","index":3,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,0,37,12],[7,11,7,12],[18,0,18,12],[21,0,21,12],[23,0,23,12],[36,0,36,12],[35,0,35,12],[20,0,20,12],[17,0,17,12],[9,1,9,12],[12,0,14,12],[34,0,34,12],[7,1,7,2],[7,4,7,5],[7,6,7,7],[7,9,7,10],[2,2,2,5],[2,6,2,10],[0,11,4,12],[1,2,1,10]]}
[]
[null,null,"CHAMPIONNAT DEPARTEMENTAL DES CLUBS"]
[null,null,{"$f":"'Base de données'!B1","v":0},null,null,null,{"$f":"'Dépôt des Licences'!U1","v":2024}]
[]
[]
[]
[]
["DATE :",{"$f":"'Base de données'!B2","v":"00:00:00"},null,null,"HEURE :",null,{"$f":"'Base de données'!B3","v":"00:00:00"},null,null,"DIVISION :",null,{"$f":"'Base de données'!B4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"."]
["LIEU :",{"$f":"'Base de données'!B5","v":0}]
[]
[]
["COMPOSITION DU JURY"]
[]
[]
[]
[]
["Président (le Délégué)"]
[{"$f":"CONCATENATE('Base de données'!B19,\" \",'Base de données'!B20)","v":" "}]
[]
["L'Arbitre principal"]
[{"$f":"CONCATENATE('Base de données'!B22,\" \",'Base de données'!B23)","v":" "}]
[]
["Membres (les capitaines des équipes)"]
[null,null,null,{"$f":"'Base de données'!B7","v":0},":",{"$f":"CONCATENATE('Dépôt des Licences'!A3,\" \",'Dépôt des Licences'!B3)","v":" "}]
[null,null,null,{"$f":"'Base de données'!B8","v":0},":",{"$f":"CONCATENATE('Dépôt des Licences'!A25,\" \",'Dépôt des Licences'!B25)","v":" "}]
[null,null,null,{"$f":"'Base de données'!B10","v":0},":",{"$f":"CONCATENATE('Dépôt des Licences'!A47,\" \",'Dépôt des Licences'!B47)","v":" "}]
[null,null,null,{"$f":"'Base de données'!B11","v":0},":",{"$f":"CONCATENATE('Dépôt des Licences'!A69,\" \",'Dépôt des Licences'!B69)","v":" "}]
[null,null,null,{"$f":"'Base de données'!B13","v":0},":",{"$f":"CONCATENATE('Dépôt des Licences'!A91,\" \",'Dépôt des Licences'!B91)","v":" "}]
[null,null,null,{"$f":"'Base de données'!B14","v":0},":",{"$f":"CONCATENATE('Dépôt des Licences'!A113,\" \",'Dépôt des Licences'!B113)","v":" "}]
[null,null,null,{"$f":"'Base de données'!B16","v":0},":",{"$f":"CONCATENATE('Dépôt des Licences'!A135,\" \",'Dépôt des Licences'!B135)","v":" "}]
[null,null,null,{"$f":"'Base de données'!B17","v":0},":",{"$f":"CONCATENATE('Dépôt des Licences'!A157,\" \",'Dépôt des Licences'!B157)","v":" "}]
[]
[null,null,"En cas d'incident joindre un rapport"]
["FFPJP - CD 74"]
["Les Berges du Foron"]
["160 Rue Perrine"]
["74800 LA ROCHE SUR FORON"]
[null,null,null,null,null,null,null,null,null,null,null,null,"F. DELAUNÉ 2023"]

{"sheet":"Match 1 recto","index":4,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[[35,0,35,16],[18,5,18,7],[23,15,23,16],[24,2,24,5],[36,0,36,16],[23,6,23,7],[23,11,23,14],[34,0,34,16],[24,6,24,7],[30,2,30,5],[30,6,30,7],[30,11,30,14],[30,15,30,16],[28,2,28,5],[28,6,28,7],[29,11,29,14],[17,1,17,7],[17,10,17,16],[22,3,22,5],[18,14,18,16],[19,3,19,7],[19,12,19,16],[21,1,21,16],[2,5,2,11],[5,1,5,16],[10,3,10,16],[14,10,15,16],[8,1,8,2],[8,7,8,9],[14,1,15,7],[10,1,10,2],[8,13,8,14],[8,10,8,11],[8,3,8,5],[8,15,8,16],[12,6,13,7],[12,15,13,16],[26,15,26,16],[29,15,29,16],[27,15,27,16],[25,2,25,5],[24,15,24,16],[25,6,25,7],[24,11,24,14],[25,11,25,14],[25,15,25,16],[33,0,33,16],[32,0,32,16],[1,5,1,14],[3,5,3,14],[28,11,28,14],[28,15,28,16],[29,2,29,5],[29,6,29,7],[27,2,27,5],[27,6,27,7],[27,11,27,14],[22,12,22,14],[23,2,23,5],[26,2,26,5],[26,6,26,7],[26,11,26,14]]}
[]
[null,null,null,null,null,"CHAMPIONNAT DEPARTEMENTAL DES CLUBS"]
[null,null,null,null,null,{"$f":"'Base de données'!B1","v":0},null,null,null,null,null,null,{"$f":"'Dépôt des Licences'!U1","v":2024}]
[null,null,null,null,null,"      Feuille de match"]
[]
[null,"Valeur des parties : Tête à tête = 2 points / Doublettes = 4 points / Triplettes = 6 points"]
[]
[]
[null,"DATE :",null,{"$f":"'Base de données'!B2","v":"00:00:00"},null,null,null,"HEURE :",null,null,{"$f":"'Base de données'!B3","v":"00:00:00"},null,null,"DIVISION :",null,{"$f":"'Base de données'!B4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[null,"LIEU :",null,{"$f":"'Base de données'!B5","v":0}]
[]
[null,"N° du club :",null,null,null,{"$f":"'Dépôt des Licences'!I3","v":0},"A",null,null,null,"N° du club :",null,null,null,{"$f":"'Dépôt des Licences'!I25","v":0},"B"]
[null,"Nom du Club :",null,null,null,null,null,null,null,null,"Nom du Club :"]
[null,{"$f":"'Base de données'!B7","v":0},null,null,null,null,null,null,null,null,{"$f":"'Base de données'!B8","v":0}]
[]
[]
[null,"CAPITAINE club A :",null,null,null,null,null,null,null,null,"CAPITAINE club B :"]
[null,"Licence N°",null,null,null,{"$f":"'Dépôt des Licences'!H3","v":0},null,null,null,null,"Licence N°",null,null,null,{"$f":"'Dépôt des Licences'!H25","v":0}]
[null,"Nom",null,{"$f":"CONCATENATE('Dépôt des Licences'!A3,\" \",'Dépôt des Licences'!B3)","v":" "},null,null,null,null,null,null,"Nom",null,{"$f":"CONCATENATE('Dépôt des Licences'!A25,\" \",'Dépôt des Licences'!B25)","v":" "}]
[]
[null,"Composition des Equipes"]
[null,null,null,"Nom - Prenom",null,null,"N° Licence",null,null,null,null,null,"Nom - Prenom",null,null,"N° Licence"]
[null,1,{"$f":"CONCATENATE('Dépôt des Licences'!A4,\" \",'Dépôt des Licences'!B4)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H4","v":0},null,null,null,1,{"$f":"CONCATENATE('Dépôt des Licences'!A26,\" \",'Dépôt des Licences'!B26)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H26","v":0}]
[null,2,{"$f":"CONCATENATE('Dépôt des Licences'!A5,\" \",'Dépôt des Licences'!B5)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H5","v":0},null,null,null,2,{"$f":"CONCATENATE('Dépôt des Licences'!A27,\" \",'Dépôt des Licences'!B27)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H27","v":0}]
[null,3,{"$f":"CONCATENATE('Dépôt des Licences'!A6,\" \",'Dépôt des Licences'!B6)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H6","v":0},null,null,null,3,{"$f":"CONCATENATE('Dépôt des Licences'!A28,\" \",'Dépôt des Licences'!B28)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H28","v":0}]
[null,4,{"$f":"CONCATENATE('Dépôt des Licences'!A7,\" \",'Dépôt des Licences'!B7)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H7","v":0},null,null,null,4,{"$f":"CONCATENATE('Dépôt des Licences'!A29,\" \",'Dépôt des Licences'!B29)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H29","v":0}]
[null,5,{"$f":"CONCATENATE('Dépôt des Licences'!A8,\" \",'Dépôt des Licences'!B8)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H8","v":0},null,null,null,5,{"$f":"CONCATENATE('Dépôt des Licences'!A30,\" \",'Dépôt des Licences'!B30)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H30","v":0}]
[null,6,{"$f":"CONCATENATE('Dépôt des Licences'!A9,\" \",'Dépôt des Licences'!B9)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H9","v":0},null,null,null,6,{"$f":"CONCATENATE('Dépôt des Licences'!A31,\" \",'Dépôt des Licences'!B31)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H31","v":0}]
[null,7,{"$f":"CONCATENATE('Dépôt des Licences'!A10,\" \",'Dépôt des Licences'!B10)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H10","v":0},null,null,null,7,{"$f":"CONCATENATE('Dépôt des Licences'!A32,\" \",'Dépôt des Licences'!B32)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H32","v":0}]
[null,8,{"$f":"CONCATENATE('Dépôt des Licences'!A11,\" \",'Dépôt des Licences'!B11)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H11","v":0},null,null,null,8,{"$f":"CONCATENATE('Dépôt des Licences'!A33,\" \",'Dépôt des Licences'!B33)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H33","v":0}]
[]
["En cas d'incident joindre un rapport"]
["FFPJP - CD 74"]
["Les Berges du Foron"]
["160 Rue Perrine"]
["74800 LA ROCHE SUR FORON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F. DELAUNÉ 2023"]

{"sheet":"Match 1 verso","index":5,"n_rows":51,"n_cols":24,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,0,50,18],[44,0,44,6],[44,9,44,12],[44,14,44,18],[47,14,47,18],[37,2,37,7],[37,12,37,17],[39,7,39,8],[39,17,39,18],[43,0,43,6],[43,9,43,12],[43,14,43,18],[27,0,37,0],[27,2,29,2],[30,2,32,2],[27,1,29,1],[30,1,32,1],[47,7,47,13],[48,7,48,13],[47,0,47,6],[48,0,48,6],[27,11,29,11],[30,11,32,11],[48,14,48,18],[27,18,29,18],[28,4,28,6],[28,14,28,16],[29,4,29,6],[29,14,29,16],[27,4,27,6],[27,7,29,7],[27,8,29,8],[27,10,37,10],[30,4,30,6],[30,7,32,7],[30,8,32,8],[35,6,35,8],[35,16,35,18],[36,6,36,8],[36,16,36,18],[33,6,33,8],[33,16,33,18],[34,6,34,8],[34,16,34,18],[30,18,32,18],[25,1,26,1],[25,2,25,7],[25,11,26,11],[25,12,25,17],[26,4,26,6],[26,14,26,16],[30,12,32,12],[30,14,30,16],[30,17,32,17],[32,14,32,16],[27,12,29,12],[27,14,27,16],[27,17,29,17],[31,4,31,6],[31,14,31,16],[32,4,32,6],[22,16,22,18],[23,2,23,7],[23,12,23,17],[15,7,16,7],[15,8,16,8],[15,11,16,11],[15,12,16,12],[15,14,15,16],[13,10,23,10],[13,11,14,11],[13,12,14,12],[13,14,13,16],[20,6,20,8],[20,16,20,18],[21,6,21,8],[21,16,21,18],[18,4,18,6],[18,14,18,16],[19,6,19,8],[19,16,19,18],[16,4,16,6],[16,14,16,16],[15,17,16,17],[13,17,14,17],[13,18,14,18],[14,14,14,16],[15,18,16,18],[17,17,18,17],[17,18,18,18],[17,11,18,11],[17,12,18,12],[17,14,17,16],[13,0,23,0],[13,1,14,1],[13,2,14,2],[13,4,13,6],[13,7,14,7],[13,8,14,8],[14,4,14,6],[15,1,16,1],[15,2,16,2],[15,4,15,6],[17,1,18,1],[17,2,18,2],[17,4,17,6],[17,7,18,7],[17,8,18,8],[22,6,22,8],[11,1,12,1],[11,2,11,7],[11,11,12,11],[11,12,11,17],[12,4,12,6],[12,14,12,16],[7,4,7,6],[7,14,7,16],[8,4,8,6],[8,14,8,16],[9,2,9,7],[9,12,9,17],[0,0,0,18],[1,1,2,1],[1,2,1,7],[1,11,2,11],[1,12,1,17],[2,4,2,6],[2,14,2,16],[3,0,9,0],[3,4,3,6],[3,10,9,10],[3,14,3,16],[4,4,4,6],[4,14,4,16],[5,4,5,6],[5,14,5,16],[6,4,6,6],[6,14,6,16]]}
["Ordre des Rencontres et Feuille de Résultats"]
[null,"Terrain",{"$f":"'Match 1 recto'!B15","v":0},null,null,null,null,null,"A",null,null,"Terrain",{"$f":"'Match 1 recto'!K15","v":0},null,null,null,null,null,"B",null,null,{"$f":"C2","v":0},{"$f":"M2","v":0}]
[null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,1,{"$f":"  'Dépôt des Licences'!A4 &\" \" & 'Dépôt des Licences'!B4","v":" "},{"$f":"  'Dépôt des Licences'!A26 &\" \" & 'Dépôt des Licences'!B26","v":" "},1]
["INDIVIDUEL",null,1,null,{"$f":"IF(D4<>\"\",VLOOKUP(D4,$U$3:$W$10,2),\"\")","v":""},null,null,null,{"$f":"IF(H4<13,0,2)","v":0},null,"INDIVIDUEL",{"$f":"IF(B4=\"\",\"\",B4)","v":""},1,null,{"$f":"IF(N4<>\"\",VLOOKUP(N4,$U$3:$W$10,3),\"\")","v":""},null,null,null,{"$f":"IF(R4<13,0,2)","v":0},null,2,{"$f":"  'Dépôt des Licences'!A5 &\" \" & 'Dépôt des Licences'!B5","v":" "},{"$f":"  'Dépôt des Licences'!A27 &\" \" & 'Dépôt des Licences'!B27","v":" "},2]
[null,null,2,null,"",null,null,null,0,null,null,{"$f":"IF(B5=\"\",\"\",B5)","v":""},2,null,{"$f":"IF(N5<>\"\",VLOOKUP(N5,$U$3:$W$10,3),\"\")","v":""},null,null,null,0,null,3,{"$f":"  'Dépôt des Licences'!A6 &\" \" & 'Dépôt des Licences'!B6","v":" "},{"$f":"  'Dépôt des Licences'!A28 &\" \" & 'Dépôt des Licences'!B28","v":" "},3]
[null,null,3,null,"",null,null,null,0,null,null,"",3,null,"",null,null,null,0,null,4,{"$f":"  'Dépôt des Licences'!A7 &\" \" & 'Dépôt des Licences'!B7","v":" "},{"$f":"  'Dépôt des Licences'!A29 &\" \" & 'Dépôt des Licences'!B29","v":" "},4]
[null,null,4,null,"",null,null,null,0,null,null,"",4,null,"",null,null,null,0,null,5,{"$f":"  'Dépôt des Licences'!A8 &\" \" & 'Dépôt des Licences'!B8","v":" "},{"$f":"  'Dépôt des Licences'!A30 &\" \" & 'Dépôt des Licences'!B30","v":" "},5]
[null,null,5,null,"",null,null,null,0,null,null,"",5,null,"",null,null,null,0,null,6,{"$f":"  'Dépôt des Licences'!A9 &\" \" & 'Dépôt des Licences'!B9","v":" "},{"$f":"  'Dépôt des Licences'!A31 &\" \" & 'Dépôt des Licences'!B31","v":" "},6]
[null,null,6,null,"",null,null,null,0,null,null,"",6,null,"",null,null,null,0,null,7,{"$f":"  'Dépôt des Licences'!A10 &\" \" & 'Dépôt des Licences'!B10","v":" "},{"$f":"  'Dépôt des Licences'!A32 &\" \" & 'Dépôt des Licences'!B32","v":" "},7]
[null,null,"S/TOTAL Pts Tête à Tête ",null,null,null,null,null,{"$f":"SUM(I4:I9)","v":0},{"$f":"I10+S10","v":0},null,null,"S/TOTAL Pts Tête à Tête ",null,null,null,null,null,{"$f":"SUM(S4:S9)","v":0},null,8,{"$f":"  'Dépôt des Licences'!A11 &\" \" & 'Dépôt des Licences'!B11","v":" "},{"$f":"  'Dépôt des Licences'!A33 &\" \" & 'Dépôt des Licences'!B33","v":" "},8]
[null,null,null,null,null,null,null,null,{"$f":"I10/2","v":0},null,null,null,null,null,null,null,null,null,{"$f":"S10/2","v":0}]
[null,"Terrain",{"$f":"'Match 1 recto'!B15","v":0},null,null,null,null,null,"A",null,null,"Terrain",{"$f":"'Match 1 recto'!K15","v":0},null,null,null,null,null,"B"]
[null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,{"$f":"C2","v":0},{"$f":"M2","v":0}]
["DOUBLETTE",null,1,null,{"$f":"IF(D14<>\"\",VLOOKUP(D14,$U$14:$W$21,2),\"\")","v":""},null,null,null,{"$f":"IF(H14<13,0,4)","v":0},null,"DOUBLETTE",{"$f":"IF(B14=\"\",\"\",B14)","v":""},1,null,{"$f":"IF(N14<>\"\",VLOOKUP(N14,$U$14:$W$21,3),\"\")","v":""},null,null,null,{"$f":"IF(R14<13,0,4)","v":0},null,1,{"$f":"  'Dépôt des Licences'!A4 &\" \" & 'Dépôt des Licences'!B4","v":" "},{"$f":"  'Dépôt des Licences'!A26 &\" \" & 'Dépôt des Licences'!B26","v":" "},1]
[null,null,null,null,{"$f":"IF(D15<>\"\",VLOOKUP(D15,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(N15<>\"\",VLOOKUP(N15,$U$14:$W$21,3),\"\")","v":""},null,null,null,null,null,2,{"$f":"  'Dépôt des Licences'!A5 &\" \" & 'Dépôt des Licences'!B5","v":" "},{"$f":"  'Dépôt des Licences'!A27 &\" \" & 'Dépôt des Licences'!B27","v":" "},2]
[null,null,2,null,"",null,null,null,{"$f":"IF(H16<13,0,4)","v":0},null,null,{"$f":"IF(B16=\"\",\"\",B16)","v":""},2,null,"",null,null,null,{"$f":"IF(R16<13,0,4)","v":0},null,3,{"$f":"  'Dépôt des Licences'!A6 &\" \" & 'Dépôt des Licences'!B6","v":" "},{"$f":"  'Dépôt des Licences'!A28 &\" \" & 'Dépôt des Licences'!B28","v":" "},3]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,4,{"$f":"  'Dépôt des Licences'!A7 &\" \" & 'Dépôt des Licences'!B7","v":" "},{"$f":"  'Dépôt des Licences'!A29 &\" \" & 'Dépôt des Licences'!B29","v":" "},4]
[null,null,3,null,"",null,null,null,{"$f":"IF(H18<13,0,4)","v":0},null,null,{"$f":"IF(B18=\"\",\"\",B18)","v":""},3,null,"",null,null,null,{"$f":"IF(R18<13,0,4)","v":0},null,5,{"$f":"  'Dépôt des Licences'!A8 &\" \" & 'Dépôt des Licences'!B8","v":" "},{"$f":"  'Dépôt des Licences'!A30 &\" \" & 'Dépôt des Licences'!B30","v":" "},5]
[null,null,null,null,{"$f":"IF(D19<>\"\",VLOOKUP(D19,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,6,{"$f":"  'Dépôt des Licences'!A9 &\" \" & 'Dépôt des Licences'!B9","v":" "},{"$f":"  'Dépôt des Licences'!A31 &\" \" & 'Dépôt des Licences'!B31","v":" "},6]
[null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(F20<>\"\",VLOOKUP(F20,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(P20<>\"\",VLOOKUP(P20,$U$14:$W$21,3),\"\")","v":""},null,null,null,7,{"$f":"  'Dépôt des Licences'!A10 &\" \" & 'Dépôt des Licences'!B10","v":" "},{"$f":"  'Dépôt des Licences'!A32 &\" \" & 'Dépôt des Licences'!B32","v":" "},7]
[null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(F21<>\"\",VLOOKUP(F21,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(P21<>\"\",VLOOKUP(P21,$U$14:$W$21,3),\"\")","v":""},null,null,null,8,{"$f":"  'Dépôt des Licences'!A11 &\" \" & 'Dépôt des Licences'!B11","v":" "},{"$f":"  'Dépôt des Licences'!A33 &\" \" & 'Dépôt des Licences'!B33","v":" "},8]
[null,"Joueur Remplacé N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplacé N°2",null,null,null,null,""]
[null,"Joueur Remplaçant N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplaçant N°2",null,null,null,null,""]
[null,null,"S/TOTAL Pts Doublette ",null,null,null,null,null,{"$f":"SUM(I14:I19)","v":0},{"$f":"I24+S24","v":0},null,null,"S/TOTAL Pts Doublette ",null,null,null,null,null,{"$f":"SUM(S14:S19)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I24/4","v":0},null,null,null,null,null,null,null,null,null,{"$f":"S24/4","v":0}]
[null,"Terrain",{"$f":"'Match 1 recto'!B15","v":0},null,null,null,null,null,"A",null,null,"Terrain",{"$f":"'Match 1 recto'!K15","v":0},null,null,null,null,null,"B"]
[null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,{"$f":"C2","v":0},{"$f":"M2","v":0}]
["TRIPLETTE",null,1,null,{"$f":"IF(D28<>\"\",VLOOKUP(D28,$U$28:$W$35,2),\"\")","v":""},null,null,null,{"$f":"IF(H28<13,0,6)","v":0},null,"TRIPLETTE",{"$f":"IF(B28=\"\",\"\",B28)","v":""},1,null,{"$f":"IF(N28<>\"\",VLOOKUP(N28,$U$28:$W$35,3),\"\")","v":""},null,null,null,{"$f":"IF(R28<13,0,6)","v":0},null,1,{"$f":"  'Dépôt des Licences'!A4 &\" \" & 'Dépôt des Licences'!B4","v":" "},{"$f":"  'Dépôt des Licences'!A26 &\" \" & 'Dépôt des Licences'!B26","v":" "},1]
[null,null,null,null,{"$f":"IF(D29<>\"\",VLOOKUP(D29,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(N29<>\"\",VLOOKUP(N29,$U$28:$W$35,3),\"\")","v":""},null,null,null,null,null,2,{"$f":"  'Dépôt des Licences'!A5 &\" \" & 'Dépôt des Licences'!B5","v":" "},{"$f":"  'Dépôt des Licences'!A27 &\" \" & 'Dépôt des Licences'!B27","v":" "},2]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,3,{"$f":"  'Dépôt des Licences'!A6 &\" \" & 'Dépôt des Licences'!B6","v":" "},{"$f":"  'Dépôt des Licences'!A28 &\" \" & 'Dépôt des Licences'!B28","v":" "},3]
[null,null,2,null,"",null,null,null,{"$f":"IF(H31<13,0,6)","v":0},null,null,{"$f":"IF(B31=\"\",\"\",B31)","v":""},2,null,"",null,null,null,{"$f":"IF(R31<13,0,6)","v":0},null,4,{"$f":"  'Dépôt des Licences'!A7 &\" \" & 'Dépôt des Licences'!B7","v":" "},{"$f":"  'Dépôt des Licences'!A29 &\" \" & 'Dépôt des Licences'!B29","v":" "},4]
[null,null,null,null,{"$f":"IF(D32<>\"\",VLOOKUP(D32,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,5,{"$f":"  'Dépôt des Licences'!A8 &\" \" & 'Dépôt des Licences'!B8","v":" "},{"$f":"  'Dépôt des Licences'!A30 &\" \" & 'Dépôt des Licences'!B30","v":" "},5]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,6,{"$f":"  'Dépôt des Licences'!A9 &\" \" & 'Dépôt des Licences'!B9","v":" "},{"$f":"  'Dépôt des Licences'!A31 &\" \" & 'Dépôt des Licences'!B31","v":" "},6]
[null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(F34<>\"\",VLOOKUP(F34,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(P34<>\"\",VLOOKUP(P34,$U$28:$W$35,3),\"\")","v":""},null,null,null,7,{"$f":"  'Dépôt des Licences'!A10 &\" \" & 'Dépôt des Licences'!B10","v":" "},{"$f":"  'Dépôt des Licences'!A32 &\" \" & 'Dépôt des Licences'!B32","v":" "},7]
[null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(F35<>\"\",VLOOKUP(F35,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(P35<>\"\",VLOOKUP(P35,$U$28:$W$35,3),\"\")","v":""},null,null,null,8,{"$f":"  'Dépôt des Licences'!A11 &\" \" & 'Dépôt des Licences'!B11","v":" "},{"$f":"  'Dépôt des Licences'!A33 &\" \" & 'Dépôt des Licences'!B33","v":" "},8]
[null,"Joueur Remplacé N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplacé N°2",null,null,null,null,""]
[null,"Joueur Remplaçant N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplaçant N°2",null,null,null,null,""]
[null,null,"S/TOTAL Pts Triplette ",null,null,null,null,null,{"$f":"SUM(I28:I33)","v":0},{"$f":"I38+S38","v":0},null,null,"S/TOTAL Pts Triplette ",null,null,null,null,null,{"$f":"SUM(S28:S33)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I38/6","v":0},{"$f":"I11+I25+I39","v":0},{"$f":"S11+S25+S39","v":0},null,null,null,null,null,null,null,{"$f":"S38/6","v":0}]
[null,null,"Total général équipe  A",null,null,null,"Pts",{"$f":"I10+I24+I38","v":0},null,{"$f":"H40+R40","v":0},null,null,"Total général équipe  B",null,null,null,"Pts",{"$f":"S10+S24+S38","v":0}]
[]
[null,null,null,null,null,null,null,"Nombre de parties Gagnées : ",{"$f":"I11+I25+I39","v":0},{"$f":"I42+S42","v":0},null,null,null,null,null,null,null,"Nombre de parties Gagnées : ",{"$f":"S11+S25+S39","v":0}]
[]
["Equipe gagnante :",null,null,null,null,null,null,{"$f":"IF(H40=R40,\"\",IF(H40>R40,\"A\",\"B\"))","v":""},null,"du club de :",null,null,null,null,{"$f":"IF(H44=\"\",\"\",IF(H44=\"A\",C2,M2))","v":""}]
["Equipe perdante :",null,null,null,null,null,null,{"$f":"IF(H40=R40,\"\",IF(H40<R40,\"A\",\"B\"))","v":""},null,"du club de :",null,null,null,null,{"$f":"IF(H40=R40,\"\",IF(H40<R40,C2,M2))","v":""}]
[null,null,null,null,null,null,null,null,null,"Match nul entre A et B :",null,null,{"$f":"IF(H40=\"\",\"\",IF(H40=R40,\"X\",\"\"))","v":"X"}]
[]
["Signat. capitaine Equipe A",null,null,null,null,null,null,"Nom-Prénom & signature de l'Arbitre ",null,null,null,null,null,null,"Signat. Capitaine Equipe B"]
[{"$f":"CONCATENATE('Dépôt des Licences'!A3,\" \",'Dépôt des Licences'!B3)","v":" "},null,null,null,null,null,null,{"$f":"CONCATENATE('Base de données'!B22,\" \",'Base de données'!B23)","v":" "},null,null,null,null,null,null,{"$f":"CONCATENATE('Dépôt des Licences'!A25,\" \",'Dépôt des Licences'!B25)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F. DELAUNÉ 2023"]
["Dans le cas d'une saisie informatique, on informe uniquement les cellules grisées et l'on fait signer"]

{"sheet":"Match 2 recto","index":6,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[[35,0,35,16],[36,0,36,16],[30,2,30,5],[30,6,30,7],[30,11,30,14],[30,15,30,16],[34,0,34,16],[32,0,32,16],[33,0,33,16],[28,2,28,5],[28,6,28,7],[28,11,28,14],[28,15,28,16],[29,2,29,5],[29,6,29,7],[29,11,29,14],[29,15,29,16],[26,2,26,5],[26,6,26,7],[26,11,26,14],[26,15,26,16],[27,2,27,5],[27,6,27,7],[27,11,27,14],[27,15,27,16],[24,2,24,5],[24,6,24,7],[24,11,24,14],[24,15,24,16],[25,2,25,5],[25,6,25,7],[25,11,25,14],[25,15,25,16],[21,1,21,16],[22,3,22,5],[22,12,22,14],[23,2,23,5],[23,6,23,7],[23,11,23,14],[23,15,23,16],[17,1,17,7],[17,10,17,16],[18,5,18,7],[18,14,18,16],[19,3,19,7],[19,12,19,16],[10,1,10,2],[10,3,10,16],[12,6,13,7],[12,15,13,16],[14,1,15,7],[14,10,15,16],[1,5,1,14],[2,5,2,11],[3,5,3,14],[5,1,5,16],[8,1,8,2],[8,3,8,5],[8,7,8,9],[8,10,8,11],[8,13,8,14],[8,15,8,16]]}
[]
[null,null,null,null,null,"CHAMPIONNAT DEPARTEMENTAL DES CLUBS"]
[null,null,null,null,null,{"$f":"'Base de données'!B1","v":0},null,null,null,null,null,null,{"$f":"'Dépôt des Licences'!U1","v":2024}]
[null,null,null,null,null,"      Feuille de match"]
[]
[null,"Valeur des parties : Tête à tête = 2 points / Doublettes = 4 points / Triplettes = 6 points"]
[]
[]
[null,"DATE :",null,{"$f":"'Base de données'!B2","v":"00:00:00"},null,null,null,"HEURE :",null,null,{"$f":"'Base de données'!B3","v":"00:00:00"},null,null,"DIVISION :",null,{"$f":"'Base de données'!B4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[null,"LIEU :",null,{"$f":"'Base de données'!B5","v":0}]
[]
[null,"N° du club :",null,null,null,{"$f":"'Dépôt des Licences'!I47","v":0},"A",null,null,null,"N° du club :",null,null,null,{"$f":"'Dépôt des Licences'!I69","v":0},"B"]
[null,"Nom du Club :",null,null,null,null,null,null,null,null,"Nom du Club :"]
[null,{"$f":"'Base de données'!B10","v":0},null,null,null,null,null,null,null,null,{"$f":"'Base de données'!B11","v":0}]
[]
[]
[null,"CAPITAINE club A :",null,null,null,null,null,null,null,null,"CAPITAINE club B :"]
[null,"Licence N°",null,null,null,{"$f":"'Dépôt des Licences'!H47","v":0},null,null,null,null,"Licence N°",null,null,null,{"$f":"'Dépôt des Licences'!H69","v":0}]
[null,"Nom",null,{"$f":"CONCATENATE('Dépôt des Licences'!A47,\" \",'Dépôt des Licences'!B47)","v":" "},null,null,null,null,null,null,"Nom",null,{"$f":"CONCATENATE('Dépôt des Licences'!A69,\" \",'Dépôt des Licences'!B69)","v":" "}]
[]
[null,"Composition des Equipes"]
[null,null,null,"Nom - Prenom",null,null,"N° Licence",null,null,null,null,null,"Nom - Prenom",null,null,"N° Licence"]
[null,1,{"$f":"CONCATENATE('Dépôt des Licences'!A48,\" \",'Dépôt des Licences'!B48)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H48","v":0},null,null,null,1,{"$f":"CONCATENATE('Dépôt des Licences'!A70,\" \",'Dépôt des Licences'!B70)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H70","v":0}]
[null,2,{"$f":"CONCATENATE('Dépôt des Licences'!A49,\" \",'Dépôt des Licences'!B49)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H49","v":0},null,null,null,2,{"$f":"CONCATENATE('Dépôt des Licences'!A71,\" \",'Dépôt des Licences'!B71)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H71","v":0}]
[null,3,{"$f":"CONCATENATE('Dépôt des Licences'!A50,\" \",'Dépôt des Licences'!B50)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H50","v":0},null,null,null,3,{"$f":"CONCATENATE('Dépôt des Licences'!A72,\" \",'Dépôt des Licences'!B72)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H72","v":0}]
[null,4,{"$f":"CONCATENATE('Dépôt des Licences'!A51,\" \",'Dépôt des Licences'!B51)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H51","v":0},null,null,null,4,{"$f":"CONCATENATE('Dépôt des Licences'!A73,\" \",'Dépôt des Licences'!B73)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H73","v":0}]
[null,5,{"$f":"CONCATENATE('Dépôt des Licences'!A52,\" \",'Dépôt des Licences'!B52)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H52","v":0},null,null,null,5,{"$f":"CONCATENATE('Dépôt des Licences'!A74,\" \",'Dépôt des Licences'!B74)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H74","v":0}]
[null,6,{"$f":"CONCATENATE('Dépôt des Licences'!A53,\" \",'Dépôt des Licences'!B53)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H53","v":0},null,null,null,6,{"$f":"CONCATENATE('Dépôt des Licences'!A75,\" \",'Dépôt des Licences'!B75)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H75","v":0}]
[null,7,{"$f":"CONCATENATE('Dépôt des Licences'!A54,\" \",'Dépôt des Licences'!B54)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H54","v":0},null,null,null,7,{"$f":"CONCATENATE('Dépôt des Licences'!A76,\" \",'Dépôt des Licences'!B76)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H76","v":0}]
[null,8,{"$f":"CONCATENATE('Dépôt des Licences'!A55,\" \",'Dépôt des Licences'!B55)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H55","v":0},null,null,null,8,{"$f":"CONCATENATE('Dépôt des Licences'!A77,\" \",'Dépôt des Licences'!B77)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H77","v":0}]
[]
["En cas d'incident joindre un rapport"]
["FFPJP - CD 74"]
["Les Berges du Foron"]
["160 Rue Perrine"]
["74800 LA ROCHE SUR FORON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F. DELAUNÉ 2023"]

{"sheet":"Match 2 verso","index":7,"n_rows":51,"n_cols":24,"rows_kept":51,"cut":false,"hidden":false,"merged":[[7,4,7,6],[7,14,7,16],[8,4,8,6],[8,14,8,16],[9,2,9,7],[9,12,9,17],[0,0,0,18],[1,1,2,1],[1,2,1,7],[1,11,2,11],[1,12,1,17],[2,4,2,6],[2,14,2,16],[3,0,9,0],[3,4,3,6],[3,10,9,10],[3,14,3,16],[4,4,4,6],[4,14,4,16],[5,4,5,6],[5,14,5,16],[6,4,6,6],[6,14,6,16],[17,4,17,6],[11,1,12,1],[11,2,11,7],[11,11,12,11],[11,12,11,17],[12,4,12,6],[12,14,12,16],[15,11,16,11],[15,12,16,12],[15,14,15,16],[15,18,16,18],[17,17,18,17],[17,18,18,18],[13,0,23,0],[13,1,14,1],[13,2,14,2],[13,4,13,6],[13,7,14,7],[13,8,14,8],[14,4,14,6],[15,1,16,1],[15,2,16,2],[15,4,15,6],[18,4,18,6],[18,14,18,16],[19,6,19,8],[19,16,19,18],[20,6,20,8],[20,16,20,18],[15,17,16,17],[15,7,16,7],[15,8,16,8],[17,1,18,1],[17,2,18,2],[25,11,26,11],[25,12,25,17],[26,4,26,6],[26,14,26,16],[21,6,21,8],[21,16,21,18],[22,6,22,8],[22,16,22,18],[23,2,23,7],[23,12,23,17],[13,10,23,10],[13,11,14,11],[16,4,16,6],[16,14,16,16],[13,12,14,12],[13,14,13,16],[13,17,14,17],[17,7,18,7],[17,8,18,8],[17,11,18,11],[17,12,18,12],[17,14,17,16],[13,18,14,18],[14,14,14,16],[27,4,27,6],[27,7,29,7],[27,8,29,8],[28,4,28,6],[29,4,29,6],[30,2,32,2],[30,4,30,6],[25,1,26,1],[25,2,25,7],[39,17,39,18],[33,6,33,8],[33,16,33,18],[34,6,34,8],[34,16,34,18],[35,6,35,8],[35,16,35,18],[32,4,32,6],[32,14,32,16],[27,10,37,10],[27,11,29,11],[27,12,29,12],[27,14,27,16],[36,6,36,8],[36,16,36,18],[37,2,37,7],[37,12,37,17],[27,17,29,17],[27,18,29,18],[28,14,28,16],[29,14,29,16],[30,17,32,17],[30,18,32,18],[27,2,29,2],[50,0,50,18],[27,0,37,0],[27,1,29,1],[30,1,32,1],[43,0,43,6],[43,9,43,12],[43,14,43,18],[44,0,44,6],[44,9,44,12],[44,14,44,18],[47,0,47,6],[47,7,47,13],[47,14,47,18],[48,0,48,6],[48,7,48,13],[48,14,48,18],[30,7,32,7],[30,8,32,8],[30,11,32,11],[30,12,32,12],[30,14,30,16],[31,4,31,6],[31,14,31,16],[39,7,39,8]]}
["Ordre des Rencontres et Feuille de Résultats"]
[null,"Terrain",{"$f":"'Match 2 recto'!B15","v":0},null,null,null,null,null,"A",null,null,"Terrain",{"$f":"'Match 2 recto'!K15","v":0},null,null,null,null,null,"B",null,null,{"$f":"C2","v":0},{"$f":"M2","v":0}]
[null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,1,{"$f":"  'Dépôt des Licences'!A48 &\" \" & 'Dépôt des Licences'!B48","v":" "},{"$f":"  'Dépôt des Licences'!A70 &\" \" & 'Dépôt des Licences'!B70","v":" "},1]
["INDIVIDUEL",null,1,null,{"$f":"IF(D4<>\"\",VLOOKUP(D4,$U$3:$W$10,2),\"\")","v":""},null,null,null,{"$f":"IF(H4<13,0,2)","v":0},null,"INDIVIDUEL",{"$f":"IF(B4=\"\",\"\",B4)","v":""},1,null,{"$f":"IF(N4<>\"\",VLOOKUP(N4,$U$3:$W$10,3),\"\")","v":""},null,null,null,{"$f":"IF(R4<13,0,2)","v":0},null,2,{"$f":"  'Dépôt des Licences'!A49 &\" \" & 'Dépôt des Licences'!B49","v":" "},{"$f":"  'Dépôt des Licences'!A71 &\" \" & 'Dépôt des Licences'!B71","v":" "},2]
[null,null,2,null,"",null,null,null,0,null,null,{"$f":"IF(B5=\"\",\"\",B5)","v":""},2,null,{"$f":"IF(N5<>\"\",VLOOKUP(N5,$U$3:$W$10,3),\"\")","v":""},null,null,null,0,null,3,{"$f":"  'Dépôt des Licences'!A50 &\" \" & 'Dépôt des Licences'!B50","v":" "},{"$f":"  'Dépôt des Licences'!A72 &\" \" & 'Dépôt des Licences'!B72","v":" "},3]
[null,null,3,null,"",null,null,null,0,null,null,"",3,null,"",null,null,null,0,null,4,{"$f":"  'Dépôt des Licences'!A51 &\" \" & 'Dépôt des Licences'!B51","v":" "},{"$f":"  'Dépôt des Licences'!A73 &\" \" & 'Dépôt des Licences'!B73","v":" "},4]
[null,null,4,null,"",null,null,null,0,null,null,"",4,null,"",null,null,null,0,null,5,{"$f":"  'Dépôt des Licences'!A52 &\" \" & 'Dépôt des Licences'!B52","v":" "},{"$f":"  'Dépôt des Licences'!A74 &\" \" & 'Dépôt des Licences'!B74","v":" "},5]
[null,null,5,null,"",null,null,null,0,null,null,"",5,null,"",null,null,null,0,null,6,{"$f":"  'Dépôt des Licences'!A53 &\" \" & 'Dépôt des Licences'!B53","v":" "},{"$f":"  'Dépôt des Licences'!A75 &\" \" & 'Dépôt des Licences'!B75","v":" "},6]
[null,null,6,null,"",null,null,null,0,null,null,"",6,null,"",null,null,null,0,null,7,{"$f":"  'Dépôt des Licences'!A54 &\" \" & 'Dépôt des Licences'!B54","v":" "},{"$f":"  'Dépôt des Licences'!A76 &\" \" & 'Dépôt des Licences'!B76","v":" "},7]
[null,null,"S/TOTAL Pts Tête à Tête ",null,null,null,null,null,{"$f":"SUM(I4:I9)","v":0},{"$f":"I10+S10","v":0},null,null,"S/TOTAL Pts Tête à Tête ",null,null,null,null,null,{"$f":"SUM(S4:S9)","v":0},null,8,{"$f":"  'Dépôt des Licences'!A55 &\" \" & 'Dépôt des Licences'!B55","v":" "},{"$f":"  'Dépôt des Licences'!A77 &\" \" & 'Dépôt des Licences'!B77","v":" "},8]
[null,null,null,null,null,null,null,null,{"$f":"I10/2","v":0},null,null,null,null,null,null,null,null,null,{"$f":"S10/2","v":0}]
[null,"Terrain",{"$f":"'Match 2 recto'!B15","v":0},null,null,null,null,null,"A",null,null,"Terrain",{"$f":"'Match 2 recto'!K15","v":0},null,null,null,null,null,"B"]
[null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,{"$f":"C2","v":0},{"$f":"M2","v":0}]
["DOUBLETTE",null,1,null,{"$f":"IF(D14<>\"\",VLOOKUP(D14,$U$14:$W$21,2),\"\")","v":""},null,null,null,{"$f":"IF(H14<13,0,4)","v":0},null,"DOUBLETTE",{"$f":"IF(B14=\"\",\"\",B14)","v":""},1,null,{"$f":"IF(N14<>\"\",VLOOKUP(N14,$U$14:$W$21,3),\"\")","v":""},null,null,null,{"$f":"IF(R14<13,0,4)","v":0},null,1,{"$f":"  'Dépôt des Licences'!A48 &\" \" & 'Dépôt des Licences'!B48","v":" "},{"$f":"  'Dépôt des Licences'!A70 &\" \" & 'Dépôt des Licences'!B70","v":" "},1]
[null,null,null,null,{"$f":"IF(D15<>\"\",VLOOKUP(D15,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(N15<>\"\",VLOOKUP(N15,$U$14:$W$21,3),\"\")","v":""},null,null,null,null,null,2,{"$f":"  'Dépôt des Licences'!A49 &\" \" & 'Dépôt des Licences'!B49","v":" "},{"$f":"  'Dépôt des Licences'!A71 &\" \" & 'Dépôt des Licences'!B71","v":" "},2]
[null,null,2,null,"",null,null,null,{"$f":"IF(H16<13,0,4)","v":0},null,null,{"$f":"IF(B16=\"\",\"\",B16)","v":""},2,null,"",null,null,null,{"$f":"IF(R16<13,0,4)","v":0},null,3,{"$f":"  'Dépôt des Licences'!A50 &\" \" & 'Dépôt des Licences'!B50","v":" "},{"$f":"  'Dépôt des Licences'!A72 &\" \" & 'Dépôt des Licences'!B72","v":" "},3]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,4,{"$f":"  'Dépôt des Licences'!A51 &\" \" & 'Dépôt des Licences'!B51","v":" "},{"$f":"  'Dépôt des Licences'!A73 &\" \" & 'Dépôt des Licences'!B73","v":" "},4]
[null,null,3,null,"",null,null,null,{"$f":"IF(H18<13,0,4)","v":0},null,null,{"$f":"IF(B18=\"\",\"\",B18)","v":""},3,null,"",null,null,null,{"$f":"IF(R18<13,0,4)","v":0},null,5,{"$f":"  'Dépôt des Licences'!A52 &\" \" & 'Dépôt des Licences'!B52","v":" "},{"$f":"  'Dépôt des Licences'!A74 &\" \" & 'Dépôt des Licences'!B74","v":" "},5]
[null,null,null,null,{"$f":"IF(D19<>\"\",VLOOKUP(D19,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,6,{"$f":"  'Dépôt des Licences'!A53 &\" \" & 'Dépôt des Licences'!B53","v":" "},{"$f":"  'Dépôt des Licences'!A75 &\" \" & 'Dépôt des Licences'!B75","v":" "},6]
[null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(F20<>\"\",VLOOKUP(F20,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(P20<>\"\",VLOOKUP(P20,$U$14:$W$21,3),\"\")","v":""},null,null,null,7,{"$f":"  'Dépôt des Licences'!A54 &\" \" & 'Dépôt des Licences'!B54","v":" "},{"$f":"  'Dépôt des Licences'!A76 &\" \" & 'Dépôt des Licences'!B76","v":" "},7]
[null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(F21<>\"\",VLOOKUP(F21,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(P21<>\"\",VLOOKUP(P21,$U$14:$W$21,3),\"\")","v":""},null,null,null,8,{"$f":"  'Dépôt des Licences'!A55 &\" \" & 'Dépôt des Licences'!B55","v":" "},{"$f":"  'Dépôt des Licences'!A77 &\" \" & 'Dépôt des Licences'!B77","v":" "},8]
[null,"Joueur Remplacé N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplacé N°2",null,null,null,null,""]
[null,"Joueur Remplaçant N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplaçant N°2",null,null,null,null,""]
[null,null,"S/TOTAL Pts Doublette ",null,null,null,null,null,{"$f":"SUM(I14:I19)","v":0},{"$f":"I24+S24","v":0},null,null,"S/TOTAL Pts Doublette ",null,null,null,null,null,{"$f":"SUM(S14:S19)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I24/4","v":0},null,null,null,null,null,null,null,null,null,{"$f":"S24/4","v":0}]
[null,"Terrain",{"$f":"'Match 2 recto'!B15","v":0},null,null,null,null,null,"A",null,null,"Terrain",{"$f":"'Match 2 recto'!K15","v":0},null,null,null,null,null,"B"]
[null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,{"$f":"C2","v":0},{"$f":"M2","v":0}]
["TRIPLETTE",null,1,null,{"$f":"IF(D28<>\"\",VLOOKUP(D28,$U$28:$W$35,2),\"\")","v":""},null,null,null,{"$f":"IF(H28<13,0,6)","v":0},null,"TRIPLETTE",{"$f":"IF(B28=\"\",\"\",B28)","v":""},1,null,{"$f":"IF(N28<>\"\",VLOOKUP(N28,$U$28:$W$35,3),\"\")","v":""},null,null,null,{"$f":"IF(R28<13,0,6)","v":0},null,1,{"$f":"  'Dépôt des Licences'!A48 &\" \" & 'Dépôt des Licences'!B48","v":" "},{"$f":"  'Dépôt des Licences'!A70 &\" \" & 'Dépôt des Licences'!B70","v":" "},1]
[null,null,null,null,{"$f":"IF(D29<>\"\",VLOOKUP(D29,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(N29<>\"\",VLOOKUP(N29,$U$28:$W$35,3),\"\")","v":""},null,null,null,null,null,2,{"$f":"  'Dépôt des Licences'!A49 &\" \" & 'Dépôt des Licences'!B49","v":" "},{"$f":"  'Dépôt des Licences'!A71 &\" \" & 'Dépôt des Licences'!B71","v":" "},2]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,3,{"$f":"  'Dépôt des Licences'!A50 &\" \" & 'Dépôt des Licences'!B50","v":" "},{"$f":"  'Dépôt des Licences'!A72 &\" \" & 'Dépôt des Licences'!B72","v":" "},3]
[null,null,2,null,"",null,null,null,{"$f":"IF(H31<13,0,6)","v":0},null,null,{"$f":"IF(B31=\"\",\"\",B31)","v":""},2,null,"",null,null,null,{"$f":"IF(R31<13,0,6)","v":0},null,4,{"$f":"  'Dépôt des Licences'!A51 &\" \" & 'Dépôt des Licences'!B51","v":" "},{"$f":"  'Dépôt des Licences'!A73 &\" \" & 'Dépôt des Licences'!B73","v":" "},4]
[null,null,null,null,{"$f":"IF(D32<>\"\",VLOOKUP(D32,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,5,{"$f":"  'Dépôt des Licences'!A52 &\" \" & 'Dépôt des Licences'!B52","v":" "},{"$f":"  'Dépôt des Licences'!A74 &\" \" & 'Dépôt des Licences'!B74","v":" "},5]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,6,{"$f":"  'Dépôt des Licences'!A53 &\" \" & 'Dépôt des Licences'!B53","v":" "},{"$f":"  'Dépôt des Licences'!A75 &\" \" & 'Dépôt des Licences'!B75","v":" "},6]
[null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(F34<>\"\",VLOOKUP(F34,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(P34<>\"\",VLOOKUP(P34,$U$28:$W$35,3),\"\")","v":""},null,null,null,7,{"$f":"  'Dépôt des Licences'!A54 &\" \" & 'Dépôt des Licences'!B54","v":" "},{"$f":"  'Dépôt des Licences'!A76 &\" \" & 'Dépôt des Licences'!B76","v":" "},7]
[null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(F35<>\"\",VLOOKUP(F35,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(P35<>\"\",VLOOKUP(P35,$U$28:$W$35,3),\"\")","v":""},null,null,null,8,{"$f":"  'Dépôt des Licences'!A55 &\" \" & 'Dépôt des Licences'!B55","v":" "},{"$f":"  'Dépôt des Licences'!A77 &\" \" & 'Dépôt des Licences'!B77","v":" "},8]
[null,"Joueur Remplacé N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplacé N°2",null,null,null,null,""]
[null,"Joueur Remplaçant N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplaçant N°2",null,null,null,null,""]
[null,null,"S/TOTAL Pts Triplette ",null,null,null,null,null,{"$f":"SUM(I28:I33)","v":0},{"$f":"I38+S38","v":0},null,null,"S/TOTAL Pts Triplette ",null,null,null,null,null,{"$f":"SUM(S28:S33)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I38/6","v":0},{"$f":"I11+I25+I39","v":0},{"$f":"S11+S25+S39","v":0},null,null,null,null,null,null,null,{"$f":"S38/6","v":0}]
[null,null,"Total général équipe  A",null,null,null,"Pts",{"$f":"I10+I24+I38","v":0},null,{"$f":"H40+R40","v":0},null,null,"Total général équipe  B",null,null,null,"Pts",{"$f":"S10+S24+S38","v":0}]
[]
[null,null,null,null,null,null,null,"Nombre de parties Gagnées : ",{"$f":"I11+I25+I39","v":0},{"$f":"I42+S42","v":0},null,null,null,null,null,null,null,"Nombre de parties Gagnées : ",{"$f":"S11+S25+S39","v":0}]
[]
["Equipe gagnante :",null,null,null,null,null,null,{"$f":"IF(H40=R40,\"\",IF(H40>R40,\"A\",\"B\"))","v":""},null,"du club de :",null,null,null,null,{"$f":"IF(H44=\"\",\"\",IF(H44=\"A\",C2,M2))","v":""}]
["Equipe perdante :",null,null,null,null,null,null,{"$f":"IF(H40=R40,\"\",IF(H40<R40,\"A\",\"B\"))","v":""},null,"du club de :",null,null,null,null,{"$f":"IF(H40=R40,\"\",IF(H40<R40,C2,M2))","v":""}]
[null,null,null,null,null,null,null,null,null,"Match nul entre A et B :",null,null,{"$f":"IF(H40=\"\",\"\",IF(H40=R40,\"X\",\"\"))","v":"X"}]
[]
["Signat. capitaine Equipe A",null,null,null,null,null,null,"Nom-Prénom & signature de l'Arbitre ",null,null,null,null,null,null,"Signat. Capitaine Equipe B"]
[{"$f":"CONCATENATE('Dépôt des Licences'!A47,\" \",'Dépôt des Licences'!B47)","v":" "},null,null,null,null,null,null,{"$f":"CONCATENATE('Base de données'!B22,\" \",'Base de données'!B23)","v":" "},null,null,null,null,null,null,{"$f":"CONCATENATE('Dépôt des Licences'!A69,\" \",'Dépôt des Licences'!B69)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F. DELAUNÉ 2023"]
["Dans le cas d'une saisie informatique, on informe uniquement les cellules grisées et l'on fait signer"]

{"sheet":"Match 3 recto","index":8,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,5,1,14],[2,5,2,11],[3,5,3,14],[5,1,5,16],[8,1,8,2],[8,3,8,5],[8,7,8,9],[8,10,8,11],[8,13,8,14],[8,15,8,16],[10,1,10,2],[10,3,10,16],[12,6,13,7],[12,15,13,16],[14,1,15,7],[14,10,15,16],[17,1,17,7],[17,10,17,16],[18,5,18,7],[18,14,18,16],[19,3,19,7],[19,12,19,16],[21,1,21,16],[22,3,22,5],[22,12,22,14],[23,2,23,5],[23,6,23,7],[23,11,23,14],[23,15,23,16],[24,2,24,5],[24,6,24,7],[24,11,24,14],[24,15,24,16],[25,2,25,5],[25,6,25,7],[25,11,25,14],[25,15,25,16],[26,2,26,5],[26,6,26,7],[26,11,26,14],[26,15,26,16],[27,2,27,5],[27,6,27,7],[27,11,27,14],[27,15,27,16],[28,2,28,5],[28,6,28,7],[28,11,28,14],[28,15,28,16],[29,2,29,5],[29,6,29,7],[29,11,29,14],[29,15,29,16],[35,0,35,16],[36,0,36,16],[30,2,30,5],[30,6,30,7],[30,11,30,14],[30,15,30,16],[34,0,34,16],[32,0,32,16],[33,0,33,16]]}
[]
[null,null,null,null,null,"CHAMPIONNAT DEPARTEMENTAL DES CLUBS"]
[null,null,null,null,null,{"$f":"'Base de données'!B1","v":0},null,null,null,null,null,null,{"$f":"'Dépôt des Licences'!U1","v":2024}]
[null,null,null,null,null,"      Feuille de match"]
[]
[null,"Valeur des parties : Tête à tête = 2 points / Doublettes = 4 points / Triplettes = 6 points"]
[]
[]
[null,"DATE :",null,{"$f":"'Base de données'!B2","v":"00:00:00"},null,null,null,"HEURE :",null,null,{"$f":"'Base de données'!B3","v":"00:00:00"},null,null,"DIVISION :",null,{"$f":"'Base de données'!B4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[null,"LIEU :",null,{"$f":"'Base de données'!B5","v":0}]
[]
[null,"N° du club :",null,null,null,{"$f":"'Dépôt des Licences'!I91","v":0},"A",null,null,null,"N° du club :",null,null,null,{"$f":"'Dépôt des Licences'!I113","v":0},"B"]
[null,"Nom du Club :",null,null,null,null,null,null,null,null,"Nom du Club :"]
[null,{"$f":"'Base de données'!B13","v":0},null,null,null,null,null,null,null,null,{"$f":"'Base de données'!B14","v":0}]
[]
[]
[null,"CAPITAINE club A :",null,null,null,null,null,null,null,null,"CAPITAINE club B :"]
[null,"Licence N°",null,null,null,{"$f":"'Dépôt des Licences'!H91","v":0},null,null,null,null,"Licence N°",null,null,null,{"$f":"'Dépôt des Licences'!H113","v":0}]
[null,"Nom",null,{"$f":"CONCATENATE('Dépôt des Licences'!A91,\" \",'Dépôt des Licences'!B91)","v":" "},null,null,null,null,null,null,"Nom",null,{"$f":"CONCATENATE('Dépôt des Licences'!A113,\" \",'Dépôt des Licences'!B113)","v":" "}]
[]
[null,"Composition des Equipes"]
[null,null,null,"Nom - Prenom",null,null,"N° Licence",null,null,null,null,null,"Nom - Prenom",null,null,"N° Licence"]
[null,1,{"$f":"CONCATENATE('Dépôt des Licences'!A92,\" \",'Dépôt des Licences'!B92)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H92","v":0},null,null,null,1,{"$f":"CONCATENATE('Dépôt des Licences'!A114,\" \",'Dépôt des Licences'!B114)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H114","v":0}]
[null,2,{"$f":"CONCATENATE('Dépôt des Licences'!A93,\" \",'Dépôt des Licences'!B93)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H93","v":0},null,null,null,2,{"$f":"CONCATENATE('Dépôt des Licences'!A115,\" \",'Dépôt des Licences'!B115)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H115","v":0}]
[null,3,{"$f":"CONCATENATE('Dépôt des Licences'!A94,\" \",'Dépôt des Licences'!B94)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H94","v":0},null,null,null,3,{"$f":"CONCATENATE('Dépôt des Licences'!A116,\" \",'Dépôt des Licences'!B116)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H116","v":0}]
[null,4,{"$f":"CONCATENATE('Dépôt des Licences'!A95,\" \",'Dépôt des Licences'!B95)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H95","v":0},null,null,null,4,{"$f":"CONCATENATE('Dépôt des Licences'!A117,\" \",'Dépôt des Licences'!B117)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H117","v":0}]
[null,5,{"$f":"CONCATENATE('Dépôt des Licences'!A96,\" \",'Dépôt des Licences'!B96)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H96","v":0},null,null,null,5,{"$f":"CONCATENATE('Dépôt des Licences'!A118,\" \",'Dépôt des Licences'!B118)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H118","v":0}]
[null,6,{"$f":"CONCATENATE('Dépôt des Licences'!A97,\" \",'Dépôt des Licences'!B97)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H97","v":0},null,null,null,6,{"$f":"CONCATENATE('Dépôt des Licences'!A119,\" \",'Dépôt des Licences'!B119)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H119","v":0}]
[null,7,{"$f":"CONCATENATE('Dépôt des Licences'!A98,\" \",'Dépôt des Licences'!B98)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H98","v":0},null,null,null,7,{"$f":"CONCATENATE('Dépôt des Licences'!A120,\" \",'Dépôt des Licences'!B120)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H120","v":0}]
[null,8,{"$f":"CONCATENATE('Dépôt des Licences'!A99,\" \",'Dépôt des Licences'!B99)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H99","v":0},null,null,null,8,{"$f":"CONCATENATE('Dépôt des Licences'!A121,\" \",'Dépôt des Licences'!B121)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H121","v":0}]
[]
["En cas d'incident joindre un rapport"]
["FFPJP - CD 74"]
["Les Berges du Foron"]
["160 Rue Perrine"]
["74800 LA ROCHE SUR FORON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F. DELAUNÉ 2023"]

{"sheet":"Match 3 verso","index":9,"n_rows":51,"n_cols":24,"rows_kept":51,"cut":false,"hidden":false,"merged":[[7,4,7,6],[7,14,7,16],[8,4,8,6],[8,14,8,16],[9,2,9,7],[9,12,9,17],[0,0,0,18],[1,1,2,1],[1,2,1,7],[1,11,2,11],[1,12,1,17],[2,4,2,6],[2,14,2,16],[3,0,9,0],[3,4,3,6],[3,10,9,10],[3,14,3,16],[4,4,4,6],[4,14,4,16],[5,4,5,6],[5,14,5,16],[6,4,6,6],[6,14,6,16],[17,4,17,6],[11,1,12,1],[11,2,11,7],[11,11,12,11],[11,12,11,17],[12,4,12,6],[12,14,12,16],[15,11,16,11],[15,12,16,12],[15,14,15,16],[15,18,16,18],[17,17,18,17],[17,18,18,18],[13,0,23,0],[13,1,14,1],[13,2,14,2],[13,4,13,6],[13,7,14,7],[13,8,14,8],[14,4,14,6],[15,1,16,1],[15,2,16,2],[15,4,15,6],[18,4,18,6],[18,14,18,16],[19,6,19,8],[19,16,19,18],[20,6,20,8],[20,16,20,18],[15,17,16,17],[15,7,16,7],[15,8,16,8],[17,1,18,1],[17,2,18,2],[25,11,26,11],[25,12,25,17],[26,4,26,6],[26,14,26,16],[21,6,21,8],[21,16,21,18],[22,6,22,8],[22,16,22,18],[23,2,23,7],[23,12,23,17],[13,10,23,10],[13,11,14,11],[16,4,16,6],[16,14,16,16],[13,12,14,12],[13,14,13,16],[13,17,14,17],[17,7,18,7],[17,8,18,8],[17,11,18,11],[17,12,18,12],[17,14,17,16],[13,18,14,18],[14,14,14,16],[27,4,27,6],[27,7,29,7],[27,8,29,8],[28,4,28,6],[29,4,29,6],[30,2,32,2],[30,4,30,6],[25,1,26,1],[25,2,25,7],[39,17,39,18],[33,6,33,8],[33,16,33,18],[34,6,34,8],[34,16,34,18],[35,6,35,8],[35,16,35,18],[32,4,32,6],[32,14,32,16],[27,10,37,10],[27,11,29,11],[27,12,29,12],[27,14,27,16],[36,6,36,8],[36,16,36,18],[37,2,37,7],[37,12,37,17],[27,17,29,17],[27,18,29,18],[28,14,28,16],[29,14,29,16],[30,17,32,17],[30,18,32,18],[27,2,29,2],[50,0,50,18],[27,0,37,0],[27,1,29,1],[30,1,32,1],[43,0,43,6],[43,9,43,12],[43,14,43,18],[44,0,44,6],[44,9,44,12],[44,14,44,18],[47,0,47,6],[47,7,47,13],[47,14,47,18],[48,0,48,6],[48,7,48,13],[48,14,48,18],[30,7,32,7],[30,8,32,8],[30,11,32,11],[30,12,32,12],[30,14,30,16],[31,4,31,6],[31,14,31,16],[39,7,39,8]]}
["Ordre des Rencontres et Feuille de Résultats"]
[null,"Terrain",{"$f":"'Match 3 recto'!B15","v":0},null,null,null,null,null,"A",null,null,"Terrain",{"$f":"'Match 3 recto'!K15","v":0},null,null,null,null,null,"B",null,null,{"$f":"C2","v":0},{"$f":"M2","v":0}]
[null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,1,{"$f":"  'Dépôt des Licences'!A92 &\" \" & 'Dépôt des Licences'!B92","v":" "},{"$f":"  'Dépôt des Licences'!A114 &\" \" & 'Dépôt des Licences'!B114","v":" "},1]
["INDIVIDUEL",null,1,null,{"$f":"IF(D4<>\"\",VLOOKUP(D4,$U$3:$W$10,2),\"\")","v":""},null,null,null,{"$f":"IF(H4<13,0,2)","v":0},null,"INDIVIDUEL",{"$f":"IF(B4=\"\",\"\",B4)","v":""},1,null,{"$f":"IF(N4<>\"\",VLOOKUP(N4,$U$3:$W$10,3),\"\")","v":""},null,null,null,{"$f":"IF(R4<13,0,2)","v":0},null,2,{"$f":"  'Dépôt des Licences'!A93 &\" \" & 'Dépôt des Licences'!B93","v":" "},{"$f":"  'Dépôt des Licences'!A115 &\" \" & 'Dépôt des Licences'!B115","v":" "},2]
[null,null,2,null,"",null,null,null,0,null,null,{"$f":"IF(B5=\"\",\"\",B5)","v":""},2,null,{"$f":"IF(N5<>\"\",VLOOKUP(N5,$U$3:$W$10,3),\"\")","v":""},null,null,null,0,null,3,{"$f":"  'Dépôt des Licences'!A94 &\" \" & 'Dépôt des Licences'!B94","v":" "},{"$f":"  'Dépôt des Licences'!A116 &\" \" & 'Dépôt des Licences'!B116","v":" "},3]
[null,null,3,null,"",null,null,null,0,null,null,"",3,null,"",null,null,null,0,null,4,{"$f":"  'Dépôt des Licences'!A95 &\" \" & 'Dépôt des Licences'!B95","v":" "},{"$f":"  'Dépôt des Licences'!A117 &\" \" & 'Dépôt des Licences'!B117","v":" "},4]
[null,null,4,null,"",null,null,null,0,null,null,"",4,null,"",null,null,null,0,null,5,{"$f":"  'Dépôt des Licences'!A96 &\" \" & 'Dépôt des Licences'!B96","v":" "},{"$f":"  'Dépôt des Licences'!A118 &\" \" & 'Dépôt des Licences'!B118","v":" "},5]
[null,null,5,null,"",null,null,null,0,null,null,"",5,null,"",null,null,null,0,null,6,{"$f":"  'Dépôt des Licences'!A97 &\" \" & 'Dépôt des Licences'!B97","v":" "},{"$f":"  'Dépôt des Licences'!A119 &\" \" & 'Dépôt des Licences'!B119","v":" "},6]
[null,null,6,null,"",null,null,null,0,null,null,"",6,null,"",null,null,null,0,null,7,{"$f":"  'Dépôt des Licences'!A98 &\" \" & 'Dépôt des Licences'!B98","v":" "},{"$f":"  'Dépôt des Licences'!A120 &\" \" & 'Dépôt des Licences'!B120","v":" "},7]
[null,null,"S/TOTAL Pts Tête à Tête ",null,null,null,null,null,{"$f":"SUM(I4:I9)","v":0},{"$f":"I10+S10","v":0},null,null,"S/TOTAL Pts Tête à Tête ",null,null,null,null,null,{"$f":"SUM(S4:S9)","v":0},null,8,{"$f":"  'Dépôt des Licences'!A99 &\" \" & 'Dépôt des Licences'!B99","v":" "},{"$f":"  'Dépôt des Licences'!A121 &\" \" & 'Dépôt des Licences'!B121","v":" "},8]
[null,null,null,null,null,null,null,null,{"$f":"I10/2","v":0},null,null,null,null,null,null,null,null,null,{"$f":"S10/2","v":0}]
[null,"Terrain",{"$f":"'Match 3 recto'!B15","v":0},null,null,null,null,null,"A",null,null,"Terrain",{"$f":"'Match 3 recto'!K15","v":0},null,null,null,null,null,"B"]
[null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,{"$f":"C2","v":0},{"$f":"M2","v":0}]
["DOUBLETTE",null,1,null,{"$f":"IF(D14<>\"\",VLOOKUP(D14,$U$14:$W$21,2),\"\")","v":""},null,null,null,{"$f":"IF(H14<13,0,4)","v":0},null,"DOUBLETTE",{"$f":"IF(B14=\"\",\"\",B14)","v":""},1,null,{"$f":"IF(N14<>\"\",VLOOKUP(N14,$U$14:$W$21,3),\"\")","v":""},null,null,null,{"$f":"IF(R14<13,0,4)","v":0},null,1,{"$f":"  'Dépôt des Licences'!A92 &\" \" & 'Dépôt des Licences'!B92","v":" "},{"$f":"  'Dépôt des Licences'!A114 &\" \" & 'Dépôt des Licences'!B114","v":" "},1]
[null,null,null,null,{"$f":"IF(D15<>\"\",VLOOKUP(D15,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(N15<>\"\",VLOOKUP(N15,$U$14:$W$21,3),\"\")","v":""},null,null,null,null,null,2,{"$f":"  'Dépôt des Licences'!A93 &\" \" & 'Dépôt des Licences'!B93","v":" "},{"$f":"  'Dépôt des Licences'!A115 &\" \" & 'Dépôt des Licences'!B115","v":" "},2]
[null,null,2,null,"",null,null,null,{"$f":"IF(H16<13,0,4)","v":0},null,null,{"$f":"IF(B16=\"\",\"\",B16)","v":""},2,null,"",null,null,null,{"$f":"IF(R16<13,0,4)","v":0},null,3,{"$f":"  'Dépôt des Licences'!A94 &\" \" & 'Dépôt des Licences'!B94","v":" "},{"$f":"  'Dépôt des Licences'!A116 &\" \" & 'Dépôt des Licences'!B116","v":" "},3]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,4,{"$f":"  'Dépôt des Licences'!A95 &\" \" & 'Dépôt des Licences'!B95","v":" "},{"$f":"  'Dépôt des Licences'!A117 &\" \" & 'Dépôt des Licences'!B117","v":" "},4]
[null,null,3,null,"",null,null,null,{"$f":"IF(H18<13,0,4)","v":0},null,null,{"$f":"IF(B18=\"\",\"\",B18)","v":""},3,null,"",null,null,null,{"$f":"IF(R18<13,0,4)","v":0},null,5,{"$f":"  'Dépôt des Licences'!A96 &\" \" & 'Dépôt des Licences'!B96","v":" "},{"$f":"  'Dépôt des Licences'!A118 &\" \" & 'Dépôt des Licences'!B118","v":" "},5]
[null,null,null,null,{"$f":"IF(D19<>\"\",VLOOKUP(D19,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,6,{"$f":"  'Dépôt des Licences'!A97 &\" \" & 'Dépôt des Licences'!B97","v":" "},{"$f":"  'Dépôt des Licences'!A119 &\" \" & 'Dépôt des Licences'!B119","v":" "},6]
[null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(F20<>\"\",VLOOKUP(F20,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(P20<>\"\",VLOOKUP(P20,$U$14:$W$21,3),\"\")","v":""},null,null,null,7,{"$f":"  'Dépôt des Licences'!A98 &\" \" & 'Dépôt des Licences'!B98","v":" "},{"$f":"  'Dépôt des Licences'!A120 &\" \" & 'Dépôt des Licences'!B120","v":" "},7]
[null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(F21<>\"\",VLOOKUP(F21,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(P21<>\"\",VLOOKUP(P21,$U$14:$W$21,3),\"\")","v":""},null,null,null,8,{"$f":"  'Dépôt des Licences'!A99 &\" \" & 'Dépôt des Licences'!B99","v":" "},{"$f":"  'Dépôt des Licences'!A121 &\" \" & 'Dépôt des Licences'!B121","v":" "},8]
[null,"Joueur Remplacé N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplacé N°2",null,null,null,null,""]
[null,"Joueur Remplaçant N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplaçant N°2",null,null,null,null,""]
[null,null,"S/TOTAL Pts Doublette ",null,null,null,null,null,{"$f":"SUM(I14:I19)","v":0},{"$f":"I24+S24","v":0},null,null,"S/TOTAL Pts Doublette ",null,null,null,null,null,{"$f":"SUM(S14:S19)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I24/4","v":0},null,null,null,null,null,null,null,null,null,{"$f":"S24/4","v":0}]
[null,"Terrain",{"$f":"'Match 3 recto'!B15","v":0},null,null,null,null,null,"A",null,null,"Terrain",{"$f":"'Match 3 recto'!K15","v":0},null,null,null,null,null,"B"]
[null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,{"$f":"C2","v":0},{"$f":"M2","v":0}]
["TRIPLETTE",null,1,null,{"$f":"IF(D28<>\"\",VLOOKUP(D28,$U$28:$W$35,2),\"\")","v":""},null,null,null,{"$f":"IF(H28<13,0,6)","v":0},null,"TRIPLETTE",{"$f":"IF(B28=\"\",\"\",B28)","v":""},1,null,{"$f":"IF(N28<>\"\",VLOOKUP(N28,$U$28:$W$35,3),\"\")","v":""},null,null,null,{"$f":"IF(R28<13,0,6)","v":0},null,1,{"$f":"  'Dépôt des Licences'!A92 &\" \" & 'Dépôt des Licences'!B92","v":" "},{"$f":"  'Dépôt des Licences'!A114 &\" \" & 'Dépôt des Licences'!B114","v":" "},1]
[null,null,null,null,{"$f":"IF(D29<>\"\",VLOOKUP(D29,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(N29<>\"\",VLOOKUP(N29,$U$28:$W$35,3),\"\")","v":""},null,null,null,null,null,2,{"$f":"  'Dépôt des Licences'!A93 &\" \" & 'Dépôt des Licences'!B93","v":" "},{"$f":"  'Dépôt des Licences'!A115 &\" \" & 'Dépôt des Licences'!B115","v":" "},2]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,3,{"$f":"  'Dépôt des Licences'!A94 &\" \" & 'Dépôt des Licences'!B94","v":" "},{"$f":"  'Dépôt des Licences'!A116 &\" \" & 'Dépôt des Licences'!B116","v":" "},3]
[null,null,2,null,"",null,null,null,{"$f":"IF(H31<13,0,6)","v":0},null,null,{"$f":"IF(B31=\"\",\"\",B31)","v":""},2,null,"",null,null,null,{"$f":"IF(R31<13,0,6)","v":0},null,4,{"$f":"  'Dépôt des Licences'!A95 &\" \" & 'Dépôt des Licences'!B95","v":" "},{"$f":"  'Dépôt des Licences'!A117 &\" \" & 'Dépôt des Licences'!B117","v":" "},4]
[null,null,null,null,{"$f":"IF(D32<>\"\",VLOOKUP(D32,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,5,{"$f":"  'Dépôt des Licences'!A96 &\" \" & 'Dépôt des Licences'!B96","v":" "},{"$f":"  'Dépôt des Licences'!A118 &\" \" & 'Dépôt des Licences'!B118","v":" "},5]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,6,{"$f":"  'Dépôt des Licences'!A97 &\" \" & 'Dépôt des Licences'!B97","v":" "},{"$f":"  'Dépôt des Licences'!A119 &\" \" & 'Dépôt des Licences'!B119","v":" "},6]
[null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(F34<>\"\",VLOOKUP(F34,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(P34<>\"\",VLOOKUP(P34,$U$28:$W$35,3),\"\")","v":""},null,null,null,7,{"$f":"  'Dépôt des Licences'!A98 &\" \" & 'Dépôt des Licences'!B98","v":" "},{"$f":"  'Dépôt des Licences'!A120 &\" \" & 'Dépôt des Licences'!B120","v":" "},7]
[null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(F35<>\"\",VLOOKUP(F35,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(P35<>\"\",VLOOKUP(P35,$U$28:$W$35,3),\"\")","v":""},null,null,null,8,{"$f":"  'Dépôt des Licences'!A99 &\" \" & 'Dépôt des Licences'!B99","v":" "},{"$f":"  'Dépôt des Licences'!A121 &\" \" & 'Dépôt des Licences'!B121","v":" "},8]
[null,"Joueur Remplacé N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplacé N°2",null,null,null,null,""]
[null,"Joueur Remplaçant N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplaçant N°2",null,null,null,null,""]
[null,null,"S/TOTAL Pts Triplette ",null,null,null,null,null,{"$f":"SUM(I28:I33)","v":0},{"$f":"I38+S38","v":0},null,null,"S/TOTAL Pts Triplette ",null,null,null,null,null,{"$f":"SUM(S28:S33)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I38/6","v":0},{"$f":"I11+I25+I39","v":0},{"$f":"S11+S25+S39","v":0},null,null,null,null,null,null,null,{"$f":"S38/6","v":0}]
[null,null,"Total général équipe  A",null,null,null,"Pts",{"$f":"I10+I24+I38","v":0},null,{"$f":"H40+R40","v":0},null,null,"Total général équipe  B",null,null,null,"Pts",{"$f":"S10+S24+S38","v":0}]
[]
[null,null,null,null,null,null,null,"Nombre de parties Gagnées : ",{"$f":"I11+I25+I39","v":0},{"$f":"I42+S42","v":0},null,null,null,null,null,null,null,"Nombre de parties Gagnées : ",{"$f":"S11+S25+S39","v":0}]
[]
["Equipe gagnante :",null,null,null,null,null,null,{"$f":"IF(H40=R40,\"\",IF(H40>R40,\"A\",\"B\"))","v":""},null,"du club de :",null,null,null,null,{"$f":"IF(H44=\"\",\"\",IF(H44=\"A\",C2,M2))","v":""}]
["Equipe perdante :",null,null,null,null,null,null,{"$f":"IF(H40=R40,\"\",IF(H40<R40,\"A\",\"B\"))","v":""},null,"du club de :",null,null,null,null,{"$f":"IF(H40=R40,\"\",IF(H40<R40,C2,M2))","v":""}]
[null,null,null,null,null,null,null,null,null,"Match nul entre A et B :",null,null,{"$f":"IF(H40=\"\",\"\",IF(H40=R40,\"X\",\"\"))","v":"X"}]
[]
["Signat. capitaine Equipe A",null,null,null,null,null,null,"Nom-Prénom & signature de l'Arbitre ",null,null,null,null,null,null,"Signat. Capitaine Equipe B"]
[{"$f":"CONCATENATE('Dépôt des Licences'!A91,\" \",'Dépôt des Licences'!B91)","v":" "},null,null,null,null,null,null,{"$f":"CONCATENATE('Base de données'!B22,\" \",'Base de données'!B23)","v":" "},null,null,null,null,null,null,{"$f":"CONCATENATE('Dépôt des Licences'!A113,\" \",'Dépôt des Licences'!B113)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F. DELAUNÉ 2023"]
["Dans le cas d'une saisie informatique, on informe uniquement les cellules grisées et l'on fait signer"]

{"sheet":"Match 4 recto","index":10,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,5,1,14],[2,5,2,11],[3,5,3,14],[5,1,5,16],[8,1,8,2],[8,3,8,5],[8,7,8,9],[8,10,8,11],[8,13,8,14],[8,15,8,16],[10,1,10,2],[10,3,10,16],[12,6,13,7],[12,15,13,16],[14,1,15,7],[14,10,15,16],[17,1,17,7],[17,10,17,16],[18,5,18,7],[18,14,18,16],[19,3,19,7],[19,12,19,16],[21,1,21,16],[22,3,22,5],[22,12,22,14],[23,2,23,5],[23,6,23,7],[23,11,23,14],[23,15,23,16],[24,2,24,5],[24,6,24,7],[24,11,24,14],[24,15,24,16],[25,2,25,5],[25,6,25,7],[25,11,25,14],[25,15,25,16],[26,2,26,5],[26,6,26,7],[26,11,26,14],[26,15,26,16],[27,2,27,5],[27,6,27,7],[27,11,27,14],[27,15,27,16],[28,2,28,5],[28,6,28,7],[28,11,28,14],[28,15,28,16],[29,2,29,5],[29,6,29,7],[29,11,29,14],[29,15,29,16],[35,0,35,16],[36,0,36,16],[30,2,30,5],[30,6,30,7],[30,11,30,14],[30,15,30,16],[32,0,32,16],[34,0,34,16],[33,0,33,16]]}
[]
[null,null,null,null,null,"CHAMPIONNAT DEPARTEMENTAL DES CLUBS"]
[null,null,null,null,null,{"$f":"'Base de données'!B1","v":0},null,null,null,null,null,null,{"$f":"'Dépôt des Licences'!U1","v":2024}]
[null,null,null,null,null,"      Feuille de match"]
[]
[null,"Valeur des parties : Tête à tête = 2 points / Doublettes = 4 points / Triplettes = 6 points"]
[]
[]
[null,"DATE :",null,{"$f":"'Base de données'!B2","v":"00:00:00"},null,null,null,"HEURE :",null,null,{"$f":"'Base de données'!B3","v":"00:00:00"},null,null,"DIVISION :",null,{"$f":"'Base de données'!B4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[null,"LIEU :",null,{"$f":"'Base de données'!B5","v":0}]
[]
[null,"N° du club :",null,null,null,{"$f":"'Dépôt des Licences'!I135","v":0},"A",null,null,null,"N° du club :",null,null,null,{"$f":"'Dépôt des Licences'!I157","v":0},"B"]
[null,"Nom du Club :",null,null,null,null,null,null,null,null,"Nom du Club :"]
[null,{"$f":"'Base de données'!B16","v":0},null,null,null,null,null,null,null,null,{"$f":"'Base de données'!B17","v":0}]
[]
[]
[null,"CAPITAINE club A :",null,null,null,null,null,null,null,null,"CAPITAINE club B :"]
[null,"Licence N°",null,null,null,{"$f":"'Dépôt des Licences'!H135","v":0},null,null,null,null,"Licence N°",null,null,null,{"$f":"'Dépôt des Licences'!H157","v":0}]
[null,"Nom",null,{"$f":"CONCATENATE('Dépôt des Licences'!A135,\" \",'Dépôt des Licences'!B135)","v":" "},null,null,null,null,null,null,"Nom",null,{"$f":"CONCATENATE('Dépôt des Licences'!A157,\" \",'Dépôt des Licences'!B157)","v":" "}]
[]
[null,"Composition des Equipes"]
[null,null,null,"Nom - Prenom",null,null,"N° Licence",null,null,null,null,null,"Nom - Prenom",null,null,"N° Licence"]
[null,1,{"$f":"CONCATENATE('Dépôt des Licences'!A136,\" \",'Dépôt des Licences'!B136)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H136","v":0},null,null,null,1,{"$f":"CONCATENATE('Dépôt des Licences'!A158,\" \",'Dépôt des Licences'!B158)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H158","v":0}]
[null,2,{"$f":"CONCATENATE('Dépôt des Licences'!A137,\" \",'Dépôt des Licences'!B137)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H137","v":0},null,null,null,2,{"$f":"CONCATENATE('Dépôt des Licences'!A159,\" \",'Dépôt des Licences'!B159)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H159","v":0}]
[null,3,{"$f":"CONCATENATE('Dépôt des Licences'!A138,\" \",'Dépôt des Licences'!B138)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H138","v":0},null,null,null,3,{"$f":"CONCATENATE('Dépôt des Licences'!A160,\" \",'Dépôt des Licences'!B160)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H160","v":0}]
[null,4,{"$f":"CONCATENATE('Dépôt des Licences'!A139,\" \",'Dépôt des Licences'!B139)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H139","v":0},null,null,null,4,{"$f":"CONCATENATE('Dépôt des Licences'!A161,\" \",'Dépôt des Licences'!B161)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H161","v":0}]
[null,5,{"$f":"CONCATENATE('Dépôt des Licences'!A140,\" \",'Dépôt des Licences'!B140)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H140","v":0},null,null,null,5,{"$f":"CONCATENATE('Dépôt des Licences'!A162,\" \",'Dépôt des Licences'!B162)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H162","v":0}]
[null,6,{"$f":"CONCATENATE('Dépôt des Licences'!A141,\" \",'Dépôt des Licences'!B141)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H141","v":0},null,null,null,6,{"$f":"CONCATENATE('Dépôt des Licences'!A163,\" \",'Dépôt des Licences'!B163)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H163","v":0}]
[null,7,{"$f":"CONCATENATE('Dépôt des Licences'!A142,\" \",'Dépôt des Licences'!B142)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H142","v":0},null,null,null,7,{"$f":"CONCATENATE('Dépôt des Licences'!A164,\" \",'Dépôt des Licences'!B164)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H164","v":0}]
[null,8,{"$f":"CONCATENATE('Dépôt des Licences'!A143,\" \",'Dépôt des Licences'!B143)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H143","v":0},null,null,null,8,{"$f":"CONCATENATE('Dépôt des Licences'!A165,\" \",'Dépôt des Licences'!B165)","v":" "},null,null,null,{"$f":"'Dépôt des Licences'!H165","v":0}]
[]
["En cas d'incident joindre un rapport"]
["FFPJP - CD 74"]
["Les Berges du Foron"]
["160 Rue Perrine"]
["74800 LA ROCHE SUR FORON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F. DELAUNÉ 2023"]

{"sheet":"Match 4 verso","index":11,"n_rows":51,"n_cols":24,"rows_kept":51,"cut":false,"hidden":false,"merged":[[7,4,7,6],[7,14,7,16],[8,4,8,6],[8,14,8,16],[9,2,9,7],[9,12,9,17],[0,0,0,18],[1,1,2,1],[1,2,1,7],[1,11,2,11],[1,12,1,17],[2,4,2,6],[2,14,2,16],[3,0,9,0],[3,4,3,6],[3,10,9,10],[3,14,3,16],[4,4,4,6],[4,14,4,16],[5,4,5,6],[5,14,5,16],[6,4,6,6],[6,14,6,16],[17,4,17,6],[11,1,12,1],[11,2,11,7],[11,11,12,11],[11,12,11,17],[12,4,12,6],[12,14,12,16],[15,11,16,11],[15,12,16,12],[15,14,15,16],[15,18,16,18],[17,17,18,17],[17,18,18,18],[13,0,23,0],[13,1,14,1],[13,2,14,2],[13,4,13,6],[13,7,14,7],[13,8,14,8],[14,4,14,6],[15,1,16,1],[15,2,16,2],[15,4,15,6],[18,4,18,6],[18,14,18,16],[19,6,19,8],[19,16,19,18],[20,6,20,8],[20,16,20,18],[15,17,16,17],[15,7,16,7],[15,8,16,8],[17,1,18,1],[17,2,18,2],[25,11,26,11],[25,12,25,17],[26,4,26,6],[26,14,26,16],[21,6,21,8],[21,16,21,18],[22,6,22,8],[22,16,22,18],[23,2,23,7],[23,12,23,17],[13,10,23,10],[13,11,14,11],[16,4,16,6],[16,14,16,16],[13,12,14,12],[13,14,13,16],[13,17,14,17],[17,7,18,7],[17,8,18,8],[17,11,18,11],[17,12,18,12],[17,14,17,16],[13,18,14,18],[14,14,14,16],[27,4,27,6],[27,7,29,7],[27,8,29,8],[28,4,28,6],[29,4,29,6],[30,2,32,2],[30,4,30,6],[25,1,26,1],[25,2,25,7],[39,17,39,18],[33,6,33,8],[33,16,33,18],[34,6,34,8],[34,16,34,18],[35,6,35,8],[35,16,35,18],[32,4,32,6],[32,14,32,16],[27,10,37,10],[27,11,29,11],[27,12,29,12],[27,14,27,16],[36,6,36,8],[36,16,36,18],[37,2,37,7],[37,12,37,17],[27,17,29,17],[27,18,29,18],[28,14,28,16],[29,14,29,16],[30,17,32,17],[30,18,32,18],[27,2,29,2],[27,0,37,0],[27,1,29,1],[30,1,32,1],[50,0,50,18],[47,0,47,6],[47,7,47,13],[47,14,47,18],[48,0,48,6],[48,7,48,13],[48,14,48,18],[43,0,43,6],[43,9,43,12],[43,14,43,18],[44,0,44,6],[44,9,44,12],[44,14,44,18],[30,7,32,7],[30,8,32,8],[30,11,32,11],[30,12,32,12],[30,14,30,16],[31,4,31,6],[31,14,31,16],[39,7,39,8]]}
["Ordre des Rencontres et Feuille de Résultats"]
[null,"Terrain",{"$f":"'Match 4 recto'!B15","v":0},null,null,null,null,null,"A",null,null,"Terrain",{"$f":"'Match 4 recto'!K15","v":0},null,null,null,null,null,"B",null,null,{"$f":"C2","v":0},{"$f":"M2","v":0}]
[null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,1,{"$f":"  'Dépôt des Licences'!A136 &\" \" & 'Dépôt des Licences'!B136","v":" "},{"$f":"  'Dépôt des Licences'!A158 &\" \" & 'Dépôt des Licences'!B158","v":" "},1]
["INDIVIDUEL",null,1,null,{"$f":"IF(D4<>\"\",VLOOKUP(D4,$U$3:$W$10,2),\"\")","v":""},null,null,null,{"$f":"IF(H4<13,0,2)","v":0},null,"INDIVIDUEL",{"$f":"IF(B4=\"\",\"\",B4)","v":""},1,null,{"$f":"IF(N4<>\"\",VLOOKUP(N4,$U$3:$W$10,3),\"\")","v":""},null,null,null,{"$f":"IF(R4<13,0,2)","v":0},null,2,{"$f":"  'Dépôt des Licences'!A137 &\" \" & 'Dépôt des Licences'!B137","v":" "},{"$f":"  'Dépôt des Licences'!A159 &\" \" & 'Dépôt des Licences'!B159","v":" "},2]
[null,null,2,null,"",null,null,null,0,null,null,{"$f":"IF(B5=\"\",\"\",B5)","v":""},2,null,{"$f":"IF(N5<>\"\",VLOOKUP(N5,$U$3:$W$10,3),\"\")","v":""},null,null,null,0,null,3,{"$f":"  'Dépôt des Licences'!A138 &\" \" & 'Dépôt des Licences'!B138","v":" "},{"$f":"  'Dépôt des Licences'!A160 &\" \" & 'Dépôt des Licences'!B160","v":" "},3]
[null,null,3,null,"",null,null,null,0,null,null,"",3,null,"",null,null,null,0,null,4,{"$f":"  'Dépôt des Licences'!A139 &\" \" & 'Dépôt des Licences'!B139","v":" "},{"$f":"  'Dépôt des Licences'!A161 &\" \" & 'Dépôt des Licences'!B161","v":" "},4]
[null,null,4,null,"",null,null,null,0,null,null,"",4,null,"",null,null,null,0,null,5,{"$f":"  'Dépôt des Licences'!A140 &\" \" & 'Dépôt des Licences'!B140","v":" "},{"$f":"  'Dépôt des Licences'!A162 &\" \" & 'Dépôt des Licences'!B162","v":" "},5]
[null,null,5,null,"",null,null,null,0,null,null,"",5,null,"",null,null,null,0,null,6,{"$f":"  'Dépôt des Licences'!A141 &\" \" & 'Dépôt des Licences'!B141","v":" "},{"$f":"  'Dépôt des Licences'!A163 &\" \" & 'Dépôt des Licences'!B163","v":" "},6]
[null,null,6,null,"",null,null,null,0,null,null,"",6,null,"",null,null,null,0,null,7,{"$f":"  'Dépôt des Licences'!A142 &\" \" & 'Dépôt des Licences'!B142","v":" "},{"$f":"  'Dépôt des Licences'!A164 &\" \" & 'Dépôt des Licences'!B164","v":" "},7]
[null,null,"S/TOTAL Pts Tête à Tête ",null,null,null,null,null,{"$f":"SUM(I4:I9)","v":0},{"$f":"I10+S10","v":0},null,null,"S/TOTAL Pts Tête à Tête ",null,null,null,null,null,{"$f":"SUM(S4:S9)","v":0},null,8,{"$f":"  'Dépôt des Licences'!A143 &\" \" & 'Dépôt des Licences'!B143","v":" "},{"$f":"  'Dépôt des Licences'!A165 &\" \" & 'Dépôt des Licences'!B165","v":" "},8]
[null,null,null,null,null,null,null,null,{"$f":"I10/2","v":0},null,null,null,null,null,null,null,null,null,{"$f":"S10/2","v":0}]
[null,"Terrain",{"$f":"'Match 4 recto'!B15","v":0},null,null,null,null,null,"A",null,null,"Terrain",{"$f":"'Match 4 recto'!K15","v":0},null,null,null,null,null,"B"]
[null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,{"$f":"C2","v":0},{"$f":"M2","v":0}]
["DOUBLETTE",null,1,null,{"$f":"IF(D14<>\"\",VLOOKUP(D14,$U$14:$W$21,2),\"\")","v":""},null,null,null,{"$f":"IF(H14<13,0,4)","v":0},null,"DOUBLETTE",{"$f":"IF(B14=\"\",\"\",B14)","v":""},1,null,{"$f":"IF(N14<>\"\",VLOOKUP(N14,$U$14:$W$21,3),\"\")","v":""},null,null,null,{"$f":"IF(R14<13,0,4)","v":0},null,1,{"$f":"  'Dépôt des Licences'!A136 &\" \" & 'Dépôt des Licences'!B136","v":" "},{"$f":"  'Dépôt des Licences'!A158 &\" \" & 'Dépôt des Licences'!B158","v":" "},1]
[null,null,null,null,{"$f":"IF(D15<>\"\",VLOOKUP(D15,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(N15<>\"\",VLOOKUP(N15,$U$14:$W$21,3),\"\")","v":""},null,null,null,null,null,2,{"$f":"  'Dépôt des Licences'!A137 &\" \" & 'Dépôt des Licences'!B137","v":" "},{"$f":"  'Dépôt des Licences'!A159 &\" \" & 'Dépôt des Licences'!B159","v":" "},2]
[null,null,2,null,"",null,null,null,{"$f":"IF(H16<13,0,4)","v":0},null,null,{"$f":"IF(B16=\"\",\"\",B16)","v":""},2,null,"",null,null,null,{"$f":"IF(R16<13,0,4)","v":0},null,3,{"$f":"  'Dépôt des Licences'!A138 &\" \" & 'Dépôt des Licences'!B138","v":" "},{"$f":"  'Dépôt des Licences'!A160 &\" \" & 'Dépôt des Licences'!B160","v":" "},3]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,4,{"$f":"  'Dépôt des Licences'!A139 &\" \" & 'Dépôt des Licences'!B139","v":" "},{"$f":"  'Dépôt des Licences'!A161 &\" \" & 'Dépôt des Licences'!B161","v":" "},4]
[null,null,3,null,"",null,null,null,{"$f":"IF(H18<13,0,4)","v":0},null,null,{"$f":"IF(B18=\"\",\"\",B18)","v":""},3,null,"",null,null,null,{"$f":"IF(R18<13,0,4)","v":0},null,5,{"$f":"  'Dépôt des Licences'!A140 &\" \" & 'Dépôt des Licences'!B140","v":" "},{"$f":"  'Dépôt des Licences'!A162 &\" \" & 'Dépôt des Licences'!B162","v":" "},5]
[null,null,null,null,{"$f":"IF(D19<>\"\",VLOOKUP(D19,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,6,{"$f":"  'Dépôt des Licences'!A141 &\" \" & 'Dépôt des Licences'!B141","v":" "},{"$f":"  'Dépôt des Licences'!A163 &\" \" & 'Dépôt des Licences'!B163","v":" "},6]
[null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(F20<>\"\",VLOOKUP(F20,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(P20<>\"\",VLOOKUP(P20,$U$14:$W$21,3),\"\")","v":""},null,null,null,7,{"$f":"  'Dépôt des Licences'!A142 &\" \" & 'Dépôt des Licences'!B142","v":" "},{"$f":"  'Dépôt des Licences'!A164 &\" \" & 'Dépôt des Licences'!B164","v":" "},7]
[null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(F21<>\"\",VLOOKUP(F21,$U$14:$W$21,2),\"\")","v":""},null,null,null,null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(P21<>\"\",VLOOKUP(P21,$U$14:$W$21,3),\"\")","v":""},null,null,null,8,{"$f":"  'Dépôt des Licences'!A143 &\" \" & 'Dépôt des Licences'!B143","v":" "},{"$f":"  'Dépôt des Licences'!A165 &\" \" & 'Dépôt des Licences'!B165","v":" "},8]
[null,"Joueur Remplacé N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplacé N°2",null,null,null,null,""]
[null,"Joueur Remplaçant N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplaçant N°2",null,null,null,null,""]
[null,null,"S/TOTAL Pts Doublette ",null,null,null,null,null,{"$f":"SUM(I14:I19)","v":0},{"$f":"I24+S24","v":0},null,null,"S/TOTAL Pts Doublette ",null,null,null,null,null,{"$f":"SUM(S14:S19)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I24/4","v":0},null,null,null,null,null,null,null,null,null,{"$f":"S24/4","v":0}]
[null,"Terrain",{"$f":"'Match 4 recto'!B15","v":0},null,null,null,null,null,"A",null,null,"Terrain",{"$f":"'Match 4 recto'!K15","v":0},null,null,null,null,null,"B"]
[null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,null,null,"N°","Nom -Prénom",null,null,"Score","Pts",null,null,{"$f":"C2","v":0},{"$f":"M2","v":0}]
["TRIPLETTE",null,1,null,{"$f":"IF(D28<>\"\",VLOOKUP(D28,$U$28:$W$35,2),\"\")","v":""},null,null,null,{"$f":"IF(H28<13,0,6)","v":0},null,"TRIPLETTE",{"$f":"IF(B28=\"\",\"\",B28)","v":""},1,null,{"$f":"IF(N28<>\"\",VLOOKUP(N28,$U$28:$W$35,3),\"\")","v":""},null,null,null,{"$f":"IF(R28<13,0,6)","v":0},null,1,{"$f":"  'Dépôt des Licences'!A136 &\" \" & 'Dépôt des Licences'!B136","v":" "},{"$f":"  'Dépôt des Licences'!A158 &\" \" & 'Dépôt des Licences'!B158","v":" "},1]
[null,null,null,null,{"$f":"IF(D29<>\"\",VLOOKUP(D29,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(N29<>\"\",VLOOKUP(N29,$U$28:$W$35,3),\"\")","v":""},null,null,null,null,null,2,{"$f":"  'Dépôt des Licences'!A137 &\" \" & 'Dépôt des Licences'!B137","v":" "},{"$f":"  'Dépôt des Licences'!A159 &\" \" & 'Dépôt des Licences'!B159","v":" "},2]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,3,{"$f":"  'Dépôt des Licences'!A138 &\" \" & 'Dépôt des Licences'!B138","v":" "},{"$f":"  'Dépôt des Licences'!A160 &\" \" & 'Dépôt des Licences'!B160","v":" "},3]
[null,null,2,null,"",null,null,null,{"$f":"IF(H31<13,0,6)","v":0},null,null,{"$f":"IF(B31=\"\",\"\",B31)","v":""},2,null,"",null,null,null,{"$f":"IF(R31<13,0,6)","v":0},null,4,{"$f":"  'Dépôt des Licences'!A139 &\" \" & 'Dépôt des Licences'!B139","v":" "},{"$f":"  'Dépôt des Licences'!A161 &\" \" & 'Dépôt des Licences'!B161","v":" "},4]
[null,null,null,null,{"$f":"IF(D32<>\"\",VLOOKUP(D32,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,5,{"$f":"  'Dépôt des Licences'!A140 &\" \" & 'Dépôt des Licences'!B140","v":" "},{"$f":"  'Dépôt des Licences'!A162 &\" \" & 'Dépôt des Licences'!B162","v":" "},5]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,6,{"$f":"  'Dépôt des Licences'!A141 &\" \" & 'Dépôt des Licences'!B141","v":" "},{"$f":"  'Dépôt des Licences'!A163 &\" \" & 'Dépôt des Licences'!B163","v":" "},6]
[null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(F34<>\"\",VLOOKUP(F34,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,"Joueur Remplacé N°1",null,null,null,null,{"$f":"IF(P34<>\"\",VLOOKUP(P34,$U$28:$W$35,3),\"\")","v":""},null,null,null,7,{"$f":"  'Dépôt des Licences'!A142 &\" \" & 'Dépôt des Licences'!B142","v":" "},{"$f":"  'Dépôt des Licences'!A164 &\" \" & 'Dépôt des Licences'!B164","v":" "},7]
[null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(F35<>\"\",VLOOKUP(F35,$U$28:$W$35,2),\"\")","v":""},null,null,null,null,"Joueur Remplaçant N°1",null,null,null,null,{"$f":"IF(P35<>\"\",VLOOKUP(P35,$U$28:$W$35,3),\"\")","v":""},null,null,null,8,{"$f":"  'Dépôt des Licences'!A143 &\" \" & 'Dépôt des Licences'!B143","v":" "},{"$f":"  'Dépôt des Licences'!A165 &\" \" & 'Dépôt des Licences'!B165","v":" "},8]
[null,"Joueur Remplacé N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplacé N°2",null,null,null,null,""]
[null,"Joueur Remplaçant N°2",null,null,null,null,"",null,null,null,null,"Joueur Remplaçant N°2",null,null,null,null,""]
[null,null,"S/TOTAL Pts Triplette ",null,null,null,null,null,{"$f":"SUM(I28:I33)","v":0},{"$f":"I38+S38","v":0},null,null,"S/TOTAL Pts Triplette ",null,null,null,null,null,{"$f":"SUM(S28:S33)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I38/6","v":0},{"$f":"I11+I25+I39","v":0},{"$f":"S11+S25+S39","v":0},null,null,null,null,null,null,null,{"$f":"S38/6","v":0}]
[null,null,"Total général équipe  A",null,null,null,"Pts",{"$f":"I10+I24+I38","v":0},null,{"$f":"H40+R40","v":0},null,null,"Total général équipe  B",null,null,null,"Pts",{"$f":"S10+S24+S38","v":0}]
[]
[null,null,null,null,null,null,null,"Nombre de parties Gagnées : ",{"$f":"I11+I25+I39","v":0},{"$f":"I42+S42","v":0},null,null,null,null,null,null,null,"Nombre de parties Gagnées : ",{"$f":"S11+S25+S39","v":0}]
[]
["Equipe gagnante :",null,null,null,null,null,null,{"$f":"IF(H40=R40,\"\",IF(H40>R40,\"A\",\"B\"))","v":""},null,"du club de :",null,null,null,null,{"$f":"IF(H44=\"\",\"\",IF(H44=\"A\",C2,M2))","v":""}]
["Equipe perdante :",null,null,null,null,null,null,{"$f":"IF(H40=R40,\"\",IF(H40<R40,\"A\",\"B\"))","v":""},null,"du club de :",null,null,null,null,{"$f":"IF(H40=R40,\"\",IF(H40<R40,C2,M2))","v":""}]
[null,null,null,null,null,null,null,null,null,"Match nul entre A et B :",null,null,{"$f":"IF(H40=\"\",\"\",IF(H40=R40,\"X\",\"\"))","v":"X"}]
[]
["Signat. capitaine Equipe A",null,null,null,null,null,null,"Nom-Prénom & signature de l'Arbitre ",null,null,null,null,null,null,"Signat. Capitaine Equipe B"]
[{"$f":"CONCATENATE('Dépôt des Licences'!A135,\" \",'Dépôt des Licences'!B135)","v":" "},null,null,null,null,null,null,{"$f":"CONCATENATE('Base de données'!B22,\" \",'Base de données'!B23)","v":" "},null,null,null,null,null,null,{"$f":"CONCATENATE('Dépôt des Licences'!A157,\" \",'Dépôt des Licences'!B157)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F. DELAUNÉ 2023"]
["Dans le cas d'une saisie informatique, on informe uniquement les cellules grisées et l'on fait signer"]

{"sheet":"Rapport sur la compatibilité","index":12,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["s","Rapport sur la compatibilité concernant CDC-O Fichier de base 2023.xls"]
[null,"Exécuté le 09/10/2023 18:54"]
[]
[null,"Les fonctionnalités suivantes de ce classeur ne sont pas prises en charge dans les versions antérieures d’Excel. Ces fonctionnalités seront peut-être perdues ou dégradées si vous ouvrez le classeur dans une version antérieure du programme ou si vous l’enregistrez dans un format de fichier antérieur."]
[]
[null,"Perte significative de fonctionnalité",null,null,"Nb d'occurrences","Version"]
[]
[null,"Certaines cellules ont plus de formats conditionnels que ce qui est pris en charge par le format de fichier sélectionné. Seules les trois premières conditions seront affichées dans les versions antérieures d'Excel.",null,null,36]
[null,null,null,null,"Feuille de Match verso'!O6:T6","Excel 97-2003"]
[null,null,null,null,"Feuille de Match verso'!O9:T9"]
[null,null,null,null,"Feuille de Match verso'!O15:T15"]
[null,null,null,null,"Feuille de Match verso'!O18:T18"]
[null,null,null,null,"Feuille de Match verso'!O28:T28"]
[null,null,null,null,"Feuille de Match verso'!O31:T31"]
[]
[null,"Certaines cellules contiennent une mise en forme conditionnelle avec l'option « Interrompre si Vrai » désactivée. Les versions antérieures d'Excel ne reconnaissent pas cette option et s'interrompront après la première condition vraie.",null,null,2]
[null,null,null,null,"Licence_Equipe2'!A13","Excel 97-2003"]
[]
[]
[null,"Perte mineure de fidélité"]
[]
[null,"Certaines formules de ce classeur sont liées à d'autres classeurs qui sont fermés. Si ces formules sont recalculées dans une version antérieure d'Excel sans ouvrir les classeurs liées, les caractères au-delà de la limite de 255 caractères ne seront pas renvoyés.",null,null,"6\nNoms définis","Excel 97-2003"]
[]
[null,"Certaines cellules ou certains styles de ce classeur contiennent une mise en forme qui n'est pas prise en charge par le format de fichier sélectionné. Ces formats seront convertis au format le plus proche disponible.",null,null,52,"Excel 97-2003"]